Jump to content

Recommended Posts

Posted
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!

Posted

You can emulate UniDbgrid Page Mode

for example 

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

Posted
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.

Posted

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

Join the conversation

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

Guest
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...