Subject Performance issue
Author Teträm Corp
Hi,

We have got a performance issue. After some tests, we think it's not
really a problem from Firebird but I hope someone already had seen the
same problem and knows a solution.

Here is the problem:

- with a distant server (tests done with OVH but our clients didn't use
OVH and has the same problem)
- only one session
- connected to via VNC _and_ TSE (we know it is the _same_ session
because doing something via VNC is reflected via TSE... so I guess it's
a console session)
- only one instance of our test application
- FB 1.5.5, Windows 2000 Server (but tested also on XP and Vista and got
same issue)

the test application does this (in Delphi 7):

Prepare;
StartOpen := Now;
Open;
OpenDelay := Now - StartOpen;
StartFetchWoDatasource := Now;
FetchAll;
FetchWoDatasourceDelay := Now - StartFetchWoDatasource;

Close;
AttacheToDatasource; // a grid is attached to the datasource
Open;
StartFetchWDatasource := Now;
FetchAll;
FetchWDatasourceDelay := Now - StartFetchWDatasource;

this code is tested with IBO (4.8) and IBX (D7 version)

The results of tests are :
via VNC: IBO is faster than IBX
via TSE: IBX is faster than IBO
via VNC is faster than via TSE (some ms versus some seconds... about
800ms vs 2s)

(Sorry I'm home so I don't have the delays values. I will be able to
post them on monday)

So because it is the same windows session, we think it is more a TSE a
problem than a Firebird problem.
Did anyone see that problem?