Performance problems on Oracle repository

[zgraja]

I have repository in Oracle 10.2.03 database. There is a big performance problem with retrieving data from this database through VPN connection (1.5 Mbps). Opening of EA project takes over 1 hour. Opening the same project in local network takes under 1 minute (and takes longer than from eap file directly). The size of this project in eap file is about 20 MB. Have you any suggestions about how to improve SQL peformance? I am using Oracle Provider for OLE DB 10.1.0.4.0.
Best regards

[«Midnight»]

Your database seems to be up to date. You might want to check your client software to see if there is something more recent, but I seriously doubt this is where the problem lies.

EA can be quite verbose when opening a repository, and this can be an issue on slower lines, so it often shows up with a VPN connection.

It is also worth testing this on the most recent EA build - it is 817 as of a few days ago.

If the problem persists, submit a bug report to Sparx. From time to time they seem to tune the DBMS interface, and this often helps the problem. However, they need to know where it is occurring in order to tweak the right thing. Since each  DBMS back end performs differently this kind of problem can occur with one product and not the others.

Sparx might also have some hints or settings that could quickly alleviate the problem.

David

[zgraja]

I am already using EA 817. Thanks for your suggestions. I'll send a bug report to Sparx.

zgraja

[thomaskilian]

Maybe you test your network connection using SQLplus (plus?  ). That might give an additional indication...

[zgraja]

I have tested my VPN connection on MS SQL Server 2005 Express. Opening EA project takes only 3 minutes (in comparison to over 60 minutes on Oracle).

zgraja

[«Midnight»]

Sparx recently tweaked SQL Server, so my guess is (still) that Oracle is out of sync. They won't know (immediately) unless you file a bug report. I suggest you do so ASAP so they can correct this before the next build.

David