Jump to content

Big data table display problem


Recommended Posts

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!

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...