Slow Oracle repository over VPN

[heinrmx]

Hello,

last year we test EA (6.5) with an Oracle (Oracle 9) repository. If you work in the LAN it is fast enought, if you login via VPN it was very slow. Last week I was on a roadshow from EA and someone told me that this was a typical problem with Oracle (because Oracle has to many overhead) and I sould use MS SQL Server or another DB as repository.
He also said, that a good Oracle DBA could solve the problem by customize the Oracle DB and I sould search in the forum for more details.

I search in the forum to find more infos about this, but I did not find any information. So here my question.

I would use
- EA 7.1
- Oracle 11 as repository
- SVN as version control system
- 95% of the worker sould use the system in a highspeed LAN
- 5% of the worker sould use the system over DSL VPN

How I have to custimize my Oracle DB that the 5% do not have to wait 50 sec. to move a object from the left side of a diagram to the right side ?
or
What could I said to my boss, that I did not want to use Oracle as repository ?

Is someone in the forum who has detailed informations why Oracle is slower than other DBs with EA, that I could explain it our Oracle DBAs that they could find a solution ?

Or is the problem solved with EA 7.1 and Oracle 11 ?

So I write to many text, sorry.

Regards Martin

[Eve]

There have been optimizations both for database access in general, and for specific oracle problems since version 6.5.  But it is still likely to be slow.  I've seen figures showing that Oracle degrades in performance faster than other databases when latency is introduced. (This is specifically in reference to EA, not Oracle in general.)

I would recommend trying individual eap files connected to the version control for the people working over VPN.  It would then only access the network to load from and save to SVN.

There should be more details about this in the deployment of EA whitepaper.

[heinrmx]

Thank you Simon for the response.