Subject | IB_Query.Next really slow |
---|---|
Author | Wolfgang |
Post date | 2012-01-27T12:03:51Z |
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
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