1
General Board / Re: EA over WAN (performance issues)
« on: March 06, 2008, 09:40:44 pm »
Wow! Quite a response! (Thanks to all who've contributed so far).
Anyway...
---
Aaron,
Thanks I'll check out the PDF. I can't quote figures off the top of my head but I'm confident our VPN is quick enough to not be the issue.
It's not like we're trying to do this over a 64k ISDN line - I've a feeling it's a 2 MB leased line. Having said that, I am concerned that traffic over that line gets prioritised so I'm looking into where in the priority list Oracle traffic sits.
I'm also sorry to say that Citrix just isn't going to happen for reasons of price, hassle and general inconvenience.
---
Dave_Bullet,
Thanks for your thorough insite into what happens when you open a model or diagram and your suggestion about SQL replication.
I was pondering a similar idea myself though we'd prefer to use Oracle - I'm sure it could be done the same - how often do you replicate your databases though?
---
Midnight,
I certainly will submit a bug report when I have more details (test results). Embarrassingly I have to admit I'm not 100% sure what version of EA the guys at the other end of the VPN are using - so maybe a simple upgrade will help speed things up.
I'm going to make sure they have the latest stable build and then run my tests. If it's still and issue I'll drop support an email.
---
Everyone else, one other work around I'm pondering is this...
We have a source control system that works well (enough) over the VPN.
So I'm thinking we could
1, Have a local EAP file and bind it to source control.
2, Distribute copies of the local EAP file to people at either end of the VPN.
The idea being the model and database are kept local to each set of users (hence EA works at normal speed) yet both models are kept in sync by virtue of the shared source control.
(That may have already been in the PDF I haven't read yet - appologies if it is).
Does anyone see any obvious issues with that idea?
Thanks again.
Chris.
Anyway...
---
Aaron,
Thanks I'll check out the PDF. I can't quote figures off the top of my head but I'm confident our VPN is quick enough to not be the issue.
It's not like we're trying to do this over a 64k ISDN line - I've a feeling it's a 2 MB leased line. Having said that, I am concerned that traffic over that line gets prioritised so I'm looking into where in the priority list Oracle traffic sits.
I'm also sorry to say that Citrix just isn't going to happen for reasons of price, hassle and general inconvenience.
---
Dave_Bullet,
Thanks for your thorough insite into what happens when you open a model or diagram and your suggestion about SQL replication.
I was pondering a similar idea myself though we'd prefer to use Oracle - I'm sure it could be done the same - how often do you replicate your databases though?
---
Midnight,
I certainly will submit a bug report when I have more details (test results). Embarrassingly I have to admit I'm not 100% sure what version of EA the guys at the other end of the VPN are using - so maybe a simple upgrade will help speed things up.
I'm going to make sure they have the latest stable build and then run my tests. If it's still and issue I'll drop support an email.
---
Everyone else, one other work around I'm pondering is this...
We have a source control system that works well (enough) over the VPN.
So I'm thinking we could
1, Have a local EAP file and bind it to source control.
2, Distribute copies of the local EAP file to people at either end of the VPN.
The idea being the model and database are kept local to each set of users (hence EA works at normal speed) yet both models are kept in sync by virtue of the shared source control.
(That may have already been in the PDF I haven't read yet - appologies if it is).
Does anyone see any obvious issues with that idea?
Thanks again.
Chris.