Then tell me please, what is the callstack ?

Guido

Jason Wharton wrote:

> 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
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/