Messages

1

Automation Interface, Add-Ins and Tools / Re: Performance Issues - EAP vs. Oracle

« on: December 02, 2010, 03:33:30 pm »

Geert,
Yes but in reading the description on the WAN Optimizer it indicates that its real advantage is in compressing the response back from the SQL server to the client.  My performance issue is mostly related to importing xmi files into the SQL server from the client.  I am not sure I will see much improvment when uploading files to the database server from the client.  Do you have any experience in this area?
Thanks...

2

Automation Interface, Add-Ins and Tools / Re: Performance Issues - EAP vs. Oracle

« on: December 01, 2010, 08:59:50 am »

Dave,
We are having the same problems you mentioned in  your note about response time/performance issues.  Our configuration is very similar with high latency on the WAN between the clients and the SQL servers.  

Did you get this problem resolved inyour enviornment?

3

Automation Interface, Add-Ins and Tools / Performance Issues - WAN Access to MS SQL Srv

« on: December 01, 2010, 08:55:22 am »

We are also having performance issues when accessing our Sparx EA SQL database across a WAN.  We feel that Latency is the issue with users experiencing 45ms to 90ms round trip delays depending on location.  Just connecting to the server from the Corporate version of Sparx EA can take several minutes and importing a large design from a local .xmi file can take over an hour.  Clients are running Windows XP.  We have both a Windows 2003/SQL 2005 and a Windows 2008/SQL 2008 server enviornment.  The Windows 2003 server sets up a TDS transport session with the client and the Windows 2008 servers uses SMB 1.0.  

What are the best ways to overcome the slow response.