Extremely slow access to remote database

[Geoffrey Phipps]

Hi,

We are experiencing extremely slow operation when using a remote database (see below). For example, clicking on the "operations" button of interface can take up to 60 seconds to populate the pulldown. In the mean time the whole application is locked. We have a complex set-up so the problem could in be in any one of a number of spots, so I am asking for advice before spending  days on it.

Our desktops are ubuntu, and our standard practise is to run EA in a windows/XP VM (Oracel virtual box). We have not tried wine.

We have an enterprise license with a central license server (also ubnuut, but wine this time).

The database is oracle

When I run a system monitor on ubuntu I can see that I have plenty of RAM, but the network traffic goes up markedly, and one of the CPUs pegs - the one running the virtual box.  On the windows side, the EA process sticks at 0%, but the EXPLORER.EXE process takes up 60% and CSRSS.EXE at 40%

Any hints? Should I stop using a windows VM and use WINE instead?

thanks in advance
Geoff

[MagnusH]

How "remote" is the database? Ping times? Is it only on the Ubuntu machines/VM you have the problem and not on native Windows desktops?

In our environment we have one central database but everyone outside that LAN is using Citrix. Connecting directly to the database gives a terrible user experience if ping time > 20 ms. Citrix is usable up to 250ms! (Our Linux users does not have to have a VM as a bonus...)

[Geoffrey Phipps]

Thanks. I'll look into the ping times. We do not use EA natively on windows, all our developers use linux (ubuntu) with virtualBox and Win XP.

We might move EA to the "corporate" PCs, which run Win XP, but that will take some time.