Subject IB_Query.Next really slow
Author Wolfgang
Hello,

on several PC following code is really slow:

IB_Query.First;
while NOT IB_Query.EOF do
IB_Query.next;
end;

Please note: In IB_Query (IB_Database, IB_Transaction) no event is implemented, no other code ist executed! every .Next lasts about 0.25 sec. On most computers the whole loop lasts about 0.25 sec...

note #2: FetchAll makes no difference...

note #3: with or without connected grid makes no difference!

there couldn't be a network problem, because this happens with embedded-installations and with client-server...

We use Delphi 7, Firebird 2.1.1 (x32)

In our Main-App we use IBO 4.7 but I try the current 4.9 - same problem....

OS: Win7 x64 but coudn't be a reason because on different other Win 7 x64 this loop is fast...
Hardware: I don't know - but a customer with 5 clients (one fast, 4 slow) use same hardware and the fast computer has lower RAM than the others...

Anybody any idea what we can try to solve the Issue?

Thanks!
Wolfgang