What is FetchWholeRows set to?
What does the SQL trace monitor reveal?

Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Wolfgang
Sent: 27 January 2012 05:04 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] IB_Query.Next really slow

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