I have always used EDB in Remote mode (connecting to the server application).  I have never tried Local mode (connecting directly to the database).  

If there is anyone who has tried both, have you noticed any general speed difference between the two?  I would think Remote mode would be faster, especially with a lot of users, but that's just an assumption.

Just curious.

= Steve

Steve


>I have always used EDB in Remote mode (connecting to the server application). I have never tried Local mode (connecting directly to the database).
>
>If there is anyone who has tried both, have you noticed any general speed difference between the two? I would think Remote mode would be faster, especially with a lot of users, but that's just an assumption.
>
>Just curious.

I did do some tests and its "interesting". So much depends on just what you're doing and the environment you're doing it in.

My findings were that generally, single user case, c/s was faster than f/s but there were some operations that were faster in f/s.

I built a test bed (thrown away now) to try and compare for my circumstances.

Things that will have some influence (not how carefully I've phrased that)

- chattiness of the application
- number of users
- speed of LAN
- loading of LAN
- number of queries
- number of filters
- duration of queries
- ratio of batch processing
- power of the server
- local vs server processing

That starter list will give you an idea why its better to build your own testbed

Roy

Steve,

<< I have always used EDB in Remote mode (connecting to the server application).  I have never tried Local mode (connecting directly to the database).  

If there is anyone who has tried both, have you noticed any general speed difference between the two?  I would think Remote mode would be faster, especially with a lot of users, but that's just an assumption. >>

Actually, remote sessions *can* experience performance issues if you tend to try to use them like you would a local session.  Meaning, doing batch processing (while (not EOF) do...Next) from the client and other types of operations that end up being very chatty.  In such cases the answer is always to move that functionality into the EDB Server in the form of a procedure/function (native or SQL).

Tim Young
Elevate Software
www.elevatesoft.com