My guess is your query is what is not functioning well.
When you are dealing with that many records you have to have a pretty
careful setup.
I don't know enough about your situation to iron out your wrinkles.
Using the SQL trace monitor would be a good starting point looking for
things that eat up your performance.

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

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "G.Allen Casteran" <allen@...>
Newsgroups: egroups.ibobjects
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, October 16, 2002 5:09 PM
Subject: Re: [IBO] HDR w/o incremental search??


> OK So it will not help me to get the initial bock of records needed for
> the grid without getting all 90K records from the server sort.
>
> I didn't think so, but based upon an e-mail that my client forwarded
> from you it almost sounded as if there was something I was missing.
>
> Thanks,
>
> Allen.
>
> In article <036501c27544$65f0eff0$dc756a41@CX170673E>,
> jwharton@... says...
> > No, HDR will operate along with all record navigations, Locate()
operations
> > and bookmark seeks as well as incremental searching.
> >
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com