Pro Cloud Server Performance

[Matthew.Seaborn]

We am currently trialling the Pro Cloud Server in order to enable Architects located in a number of separate countries to collaborate, under the assumption that his would perform better than a single direct database connection.

However we have had significant performance issues.

It is currently sat on an Oracle 12 database, which I understand others have had performance issues with.  However that doesn't seem to be the problem; instead it is due to communication latency.

The UI is perfectly usable when in the same office as the cloud server, but when accessing from near-but-external to the office or from another country where the TTFB is even higher, the UI becomes extremely slow and ultimately unusable.

The cause of this problem appears to be down to how extremely chatty the UI is; simply creating an object by dragging it onto a diagram and then clicking OK on the pop-up requires 118 HTTP requests to the Cloud server.  With so many requests, in increase in latency of just 9ms will cause 1 second slowdown for that simple operation, and we are seeing much, much greater slowdown than that.

Has anyone got the Pro Cloud Server to work with an international team?  Can anyone advise how to make this usable?

[Nizam]

Using EA from a remote location has its performance implications as you've mentioned, but having done this in quite a few clients, these are my observations
1. Oracle is particularly slow, so much so that in some clients where Oracle is the DB we have retorted to using emulation based setup
2. Cloud Connection on MS SQL Server DB (configured with OLEDB) connectivity is the best amongst available databases. (especially using Connect to Cloud)
3. However, Connect via cloud has been relatively better than connecting via ODBC / OLEDB direct

You can also consider separating concerns, by allowing only the modelers to connect via EA, and others to use the web publishing platforms. In that way, those stakeholders who have to consume the models for various purposes could just stick to a browser and view model information.

[Geert Bellekens]

Has anyone got the Pro Cloud Server to work with an international team?  Can anyone advise how to make this usable?

Not the answer you are looking for, but I have some pretty good experiences using a terminal setup such as Microsoft Remote apps, or Citrix.
This works even on fairly low speed connections as it only send the application image over the network.
Performance of the application is the best you can get as both the remote server as the database can be located in the same datacenter.

Geert

PS. Oh, and don't use Oracle for EA. I've yet to meet someone who succeeded in getting EA to run smoothly on an Oracle database. 

[Sunshine]

Just confirming what others have said previously about Oracle. I've been in a number of organisations where Oracle is the defacto DB with  Sparx EA and every time there has been performance issues. I've had a number of Oracle DB Admins look at it but can't seem to improve it. In organisations where we've used SQL Server we've had no issues with performance.
Not sure if it would help with Pro Cloud Server but there is a WAN optimiser for Sparx EA.

[Eve]

Not sure if it would help with Pro Cloud Server but there is a WAN optimiser for Sparx EA.

Pro Cloud Server is a replacement for the WAN optimizer.