Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread TIP: DBISam and QuantumGrid Speed
Thu, May 11 2006 11:27 PMPermanent Link

"Adam H."
Hi,

I've just came across a rather large speed improvement with DBISam queries
and using Quantumgrid which I thought I'd share.

I find (on large tables / results), that if you use a standard DBGrid, then
setting Requestlive to true causes speed improvements (as not all the data
is loaded, but only that which the grid needs to display).

However, with Quantumgrid, it loads all the data as it is required for the
benefit of filters, sorting, etc.

I noticed that if I used a query, and set RequestLive to False on
quantumgrid datasets, it improved the loading of quantumgrid significantly.

Hope this helps someone.

Cheers

Adam.

--
There is a principle which is a bar against all information, which cannot
fail to keep a man in everlasting ignorance-- that principle is contempt
prior to investigation." - Herbert Spencer, British philosopher.

Sun, May 21 2006 7:25 AMPermanent Link

Graham Wood
Will try that ASAP.

FYI, I got boggling improvements in D7 for cxGrids by using FastMM4.  Search for it at
sourceforge.net.
Like 10 times faster, seriously - sweeeet Smiley

Just change your DPR to:

program MyApp;

uses
 FastMM4,
 MyOtherUnits,
 Etc.


Sun, May 21 2006 11:06 PMPermanent Link

"Adam H."
Hi Graham,

Thanks for the tip. I keep forgetting about the 3rd party memory managers.
Will give this a go and see if it does the same with my applications!

Thanks again!

Adam.
> FYI, I got boggling improvements in D7 for cxGrids by using FastMM4.
> Search for it at
> sourceforge.net.
> Like 10 times faster, seriously - sweeeet Smiley
>
> Just change your DPR to:
>
> program MyApp;
>
> uses
>  FastMM4,
>  MyOtherUnits,
>  Etc.
>
>
>

Image