I have no idea what could be wrong.
It should work just fine without fetching all the records in the buffer.
If you say it is fetching all rows, I would like to see the callstack to
determine what has it fetching rows like that.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <guido.klapperich@...>
To: "IBObjects" <IBObjects@yahoogroups.com>
Sent: Wednesday, November 07, 2001 3:50 PM
Subject: [IBO] Ordering-Problem


> I have a customers-table with a column Name (NOT NULL) and 2 indices on
> this column, one ascending and the other descending. At the query which
> selects from this table, I have OrderingItem
> Name=NAME;NAME DESC
> and OrderingLink
> NAME=ITEM=1;POS=0
> When I open the query and want to order by Name ascending, it takes
> nearly a minute. With the callback-mechanism I see, that IBO fetches all
> data (in this case 7000 customers) three times over the network until it
> has finished.
> When I order by Name descending it takes only 2 seconds, as expected.
> Now I order by Name ascending again, same procedure as described above.
> Any ideas, where the problem is ?
>
>
> Guido