Slow access to a large DB shared project

[Guillaume]

Hi,

I'm looking at the options available in an attempt to improve slow access to a very large EA project that's shared via a centralised DB (no SVN):
1- install a WANOptimizer
2- install a cloud service
3- run DB optimisation (?)

First, is there any difference between using a WANOptimizer or a Cloud Service for LAN accesses? Has anyone got an experience in seeing improvements from using either tool on a LAN?

When an EA project becomes really large, is there any improvement that can be obtained via DB optimisation in the DBMS itself?

Thanks

[Uffe]

Hey Guillaume,


The first is-it-plugged-in type question is "are you using lazy load"? You didn't mention it in your post so it's worth a check. If you're not lazy-loading, the entire project is transferred to the client when connecting.

As to the database itself, I'm no DBA but it's always a good idea to keep an eye on the transaction logs. Not aware of any EA-specific issues, but still. If they get out-of-control huge you'll see a performance decrease on the server side.

WanOptimizer vs Cloud Services: no idea, sorry.

Other than that, is there any other network congestion going on? Is the same DB server used for other purposes, and are those users experiencing similar loads? &c.

HTH,


/Uffe

[Geert Bellekens]

I don't think Clould or WAN will do anything in a LAN environment.

It might certainly be interesting to check the database for possible performance improvements.
Sometimes adding an index can make  big difference.

But usually the biggest bottleneck with situations like these is the bandwidth of the connection between the client and the database.

The EA client executes up to hundreds of small queries each second, so if you have any latency in the network connection that is going to get multiplied by the number of queries it executes.

Geert

[Guillaume]

Hi Geert and Uffe,

Thank you for your replies. I will look into the suggested options and will let you know if we somehow manage to improve the performance.

Cheers