Jump to content


Photo

Large amount of rows / filtering


  • Please log in to reply
2 replies to this topic

#1 rincewind

rincewind
  • Members
  • 2 posts

Posted 11 December 2009 - 07:50 PM

Hi,

I try to filter a huge amount of rows (about 380,000 rows). I use a progressbar to show that the application ist still working, but the progress slows down during the process and stops at about 50 % unsure.gif

What I do to filter the grid ist the following:
CODE
FOR i := 0 TO sgDaten.RowCount - 1
DO BEGIN
IF sgDaten.Cells[AktSpalte,i] = sFilter
THEN sgDaten.RowVisible[i] := TRUE
ELSE sgDaten.RowVisible[i] := FALSE;
PercentBar.Progress := i;
END;

Is there an explanation for this slow down or is there a better way of filtering ?

#2 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,196 posts
  • Gender:Male

Posted 11 December 2009 - 10:49 PM

Hello,

Try to add BeginUpdate/EndUpdate calls on start and end of a working code. More info at: http://dn.bergsoft.n...ze-nextgrid.htm

I hope that this will help.

Best regards
boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.

#3 rincewind

rincewind
  • Members
  • 2 posts

Posted 16 December 2009 - 11:06 AM

QUOTE (Boki (Berg) @ Dec 11 2009, 10:49 PM) <{POST_SNAPBACK}>
Hello,

Try to add BeginUpdate/EndUpdate calls on start and end of a working code. More info at: http://dn.bergsoft.n...ze-nextgrid.htm

I hope that this will help.

Best regards


Hello,

yes, it's faster now.
But even now, faster means about 2 hours for that amount of rows.
And I don't understand why it's slowing down during the process.

Regards





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users