Is there a virtual stringgrid lazarus / 31-LCL ---------------------------------------------------------------------- Zaher · 2015-09-02 13:55 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 · 2015-09-02 13:58 TDrawGrid http://wiki.freepascal.org/Grids_Reference_Page http://www.festra.com/wwwboard/messages/1016.html ---------------------------------------------------------------------- Zaher · 2015-09-02 14:02 No, Virtual meant even ColCount and RowCount is virtual too ---------------------------------------------------------------------- Groffy · 2015-09-02 14:07 Try KGrid with option [goVirtualGrid] or TVirtualStringTree thats virtual by default ---------------------------------------------------------------------- derek.john.evans · 2015-09-02 14:09 Quote from: Zaher on September 02, 2015, 04:02:52 pmNo, 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 · 2015-09-02 14:14 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... ---------------------------------------------------------------------- fred · 2015-09-02 15:43 When you increment RowCount by 1 it is slow, try incrementing it by eg. 1000 and set the correct RowCount at the end. ---------------------------------------------------------------------- Zaher · 2015-09-02 19:47 @fred Ah good idea ---------------------------------------------------------------------- Zaher · 2015-09-03 21:30 @fred Yes, my customer said: it loaded like a charm, it is flying Thank you ---------------------------------------------------------------------- fred · 2015-09-04 07:50 Glad that it works for you too