Cloud Services preformance

[Darth Vader]

Hi,
I've got a performance issue with Cloud Services. Our common repository is hosted on MySQL server instance and users access it through CS. However, almost all operations take very long time even if there is only one user accesing DB. For example, adding an element to a diagram takes about 5 seconds to complete.
Initially I was thinking that this is the DB problem, but later I realized that if I connect to the DB directly via ODBC without CS, everythigs works fine and quickly.
What can I do with Cloud Services app to speed it up? It is working in standalone mode without a web server and without SSL.
Server:
- Windos Server 2008
- CPU dual Xeon X5570
- 12 Gb RAM

[Geert Bellekens]

Question: are you using Cloud Service in a LAN environment?

If that is the case, that doesn't make much sense to me.
Cloud service is aimed at WAN environments, to expose your model over HTTP to distributed users.

In a LAN environment you connect directly to the database over ODBC.

Geert

[Darth Vader]

Yes, in LAN environment.
According to the Sparx documentation, CS can be used to simplify user setup and secure connections to DB via HTTP, this also matters for LAN users.
With CS I can, for example, migrate to different DB and no one will notice this.
In fact, it doesn't matter why we choose CS instead of ODBC. It does matters why it is so slow. Such delays are inappropriate even for WAN users.

[Geert Bellekens]

OK, have it your way then. :-/

Geert

[Paolo F Cantoni]

Hi Darth,

I understand your point of view, but Geert is also correct.  The general rule of thumb is: don't use extended functionality unless you have to.

That having been said, I'd make use of CS's ability to abstract out the DB technology to swap it and see if the problem is localized to MySQL.  Use Project Transfer to make a clone of the DB in the new technology.

If possible, try SQL Server - since I believe Sparx is an MS shop.  There are a lot of idiosyncrasies injected due to DB technology variances.

HTH,
Paolo