Big data table display problem

[leozem]

Connect the Firebird with UniDBGrid->DataSource->FDTable->FDConnect, table has 200 million pieces of data. FDTable.FetchOptions: = [evUnidirectional], UniDBGrid the page mode, memory should be for the PageSize * 2, but when FDTable.Active: =True; and will read all of the 200 million pieces of data and lead to run out of memory.

In VCL, the UniDBGrid will be replaced by DBGrid after all the normal.

Don't know where the problem is.

Hope to provide a large data table display examples, thank you!

[stas]

You can emulate UniDbgrid Page Mode

for example 

select first [PageCount] skip [PageCount]*[NPage-1] B.* FROM BIGTABLE B

[Farshad Mohajeri]

Please specify your uniGUI version.

[leozem]

0.99.80.1249,  0.99.95.1309  The two versions have the same problem.

[Farshad Mohajeri]

0.99.80.1249,  0.99.95.1309  The two versions have the same problem.

 

Trial edition?

[leozem]

yes

[leozem]

Is there a way to solve it?

[Farshad Mohajeri]

First way is to limit amount of data by optimizing your SQL query. Set a limit to max number of rows.

BTW,  Unidirectional datasets are not compatible with grids. Try changing it to a different mode.

[leozem]

In VCL, FDQuery Unidirectional can not be used, but FDTable Unidirectional can be a good job.

If UNIGUI does not support, if there are 10000 pieces of data in the table, enter the user will read the 10000 data to the server memory, the user increases, the great occupation server resources, do not know there is nothing wrong with my understanding.

[leozem]

Or, again, how to customize the first and next PagingToolbar and other button events, I want to try to use the code to dynamically obtain the paging data.

thanks