TMS FNC UI Pack

TMS Non-Technical
1

Hello,

What is the maximum col and row count in new FNC Grid, (in TMS FNC UI Pack), for 64bits and 16GB PC?

regards

Ertan

3

The ColumnCount / RowCount (without data) we have tested with is

TMSFNCDataGrid1.ColumnCount := 100000;
TMSFNCDataGrid1.RowCount := 1000000;

in a 64 bit application which regardless of the amount of available memory is still acceptable in terms of performance.

It needs about 1gb of memory.

The data should then be served via OnGetCellData (virtually).

When the data is loaded in memory it ramps up quite fast and exceeds the limit of 16gb with this configuration.

With this configuration for example, it reaches 18gb of memory used (with data loaded in memory)

TMSFNCDataGrid1.BeginUpdate;
TMSFNCDataGrid1.ColumnCount := 1000;
TMSFNCDataGrid1.RowCount := 100000;
TMSFNCDataGrid1.LoadSampleData;
TMSFNCDataGrid1.EndUpdate;

Depending on your requirements, the best option would be to use virtual data, which can be fed to the grid via the OnGetCellData event.

4

Thanks! If I have a csv file with 500 Colums and 100000 Rows how can I open it as virtual data and put into cells via OnGetCellData event. Do you have an small example of code?

Kind Regards

5

You can look at TMSFNCDataSet with TMSFNCDataLinkCSV component

1 Like