Recent

Author Topic: Is there a virtual stringgrid  (Read 6181 times)

Zaher

  • Hero Member
  • *****
  • Posts: 679
    • parmaja.org
Is there a virtual stringgrid
« on: September 02, 2015, 03:55:40 pm »
TStringGrid is slow by filling it about millions of record, I used BeginUpdate but same slow
I compared it with exporting my data to csv and open it with Excel sheet, it was very fast.

So
Is there a virtual stringgrid to use my own memory callback?

thanks

derek.john.evans

  • Guest

Zaher

  • Hero Member
  • *****
  • Posts: 679
    • parmaja.org
Re: Is there a virtual stringgrid
« Reply #2 on: September 02, 2015, 04:02:52 pm »
No, Virtual meant even ColCount and RowCount is virtual too

Groffy

  • Full Member
  • ***
  • Posts: 204
Re: Is there a virtual stringgrid
« Reply #3 on: September 02, 2015, 04:07:44 pm »
Try KGrid with option [goVirtualGrid] or TVirtualStringTree thats virtual by default


Linux Mint / Windows 10 / Lazarus 3.0.0 / trunk -qt

derek.john.evans

  • Guest
Re: Is there a virtual stringgrid
« Reply #4 on: September 02, 2015, 04:09:28 pm »
No, Virtual meant even ColCount and RowCount is virtual too

ColCount and RowCount define the number of virtual cells. Have a look at the Inheritance Tree here to see how TDBGrid fits into everything.

http://wiki.freepascal.org/Grids_Reference_Page

wp

  • Hero Member
  • *****
  • Posts: 11857
Re: Is there a virtual stringgrid
« Reply #5 on: September 02, 2015, 04:14:59 pm »
You mention Excel. Did you try TsSpreadsheetGrid from the fpspreadsheet library (http://wiki.lazarus.freepascal.org/FPSpreadsheet)?

I doubt that a gui with millions of lines in a grid is good, though...
« Last Edit: September 02, 2015, 05:45:00 pm by wp »

fred

  • Full Member
  • ***
  • Posts: 201
Re: Is there a virtual stringgrid
« Reply #6 on: September 02, 2015, 05:43:30 pm »
When you increment RowCount by 1 it is slow, try incrementing it by eg. 1000 and set the correct RowCount at the end.

Zaher

  • Hero Member
  • *****
  • Posts: 679
    • parmaja.org
Re: Is there a virtual stringgrid
« Reply #7 on: September 02, 2015, 09:47:22 pm »
@fred Ah good idea

Zaher

  • Hero Member
  • *****
  • Posts: 679
    • parmaja.org
Re: Is there a virtual stringgrid
« Reply #8 on: September 03, 2015, 11:30:53 pm »
@fred Yes, my customer said: it loaded like a charm, it is flying

Thank you

fred

  • Full Member
  • ***
  • Posts: 201
Re: Is there a virtual stringgrid
« Reply #9 on: September 04, 2015, 09:50:02 am »
Glad that it works for you too  8)

 

TinyPortal © 2005-2018