Subject Re: [IBO] HDR w/o incremental search??
Author Jason Wharton
No, HDR will operate along with all record navigations, Locate() operations
and bookmark seeks as well as incremental searching.

Jason Wharton
CPS - Mesa AZ

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

----- Original Message -----
From: "G.Allen Casteran" <allen@...>
Newsgroups: egroups.ibobjects
To: <>
Sent: Monday, October 14, 2002 2:03 AM
Subject: [IBO] HDR w/o incremental search??

> Is the HDR only applicable to incremental searches?
> If I have a query with multiple Left Outer Joins and the resulting Order
> by uses fields from the joined tables, is there a way that HDR can help
> improve the speed to get the first page of data for my grid?
> Right now it is taking about 75 seconds to get a response in the
> InfoPower grid after pulling together about 90K records in a query that
> runs a sort on the server with all the resulting 90K rows before
> anything is returned to the client.
> As I understand it this is correct behavior and part of the performance
> hit of doing an Order By on such a large result set. The joins are all
> using indexes already.
> I know that 90K records are a lot to bring into a grid and it is not my
> design. The client is insistant about having to load all this into the
> grid.
> I fisrt moved a Where clause up into the Joins and that improved the
> response from 5 minutes to 75 seconds, but it would be nice to get an
> even faster response.
> Any suggestions?
> Thanks,
> Allen.