leozem Posted August 2, 2016 Posted August 2, 2016 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! Quote
stas Posted August 2, 2016 Posted August 2, 2016 You can emulate UniDbgrid Page Mode for example select first [PageCount] skip [PageCount]*[NPage-1] B.* FROM BIGTABLE B Quote
Administrators Farshad Mohajeri Posted August 2, 2016 Administrators Posted August 2, 2016 Please specify your uniGUI version. Quote
leozem Posted August 3, 2016 Author Posted August 3, 2016 0.99.80.1249, 0.99.95.1309 The two versions have the same problem. Quote
Administrators Farshad Mohajeri Posted August 3, 2016 Administrators Posted August 3, 2016 0.99.80.1249, 0.99.95.1309 The two versions have the same problem. Trial edition? Quote
Administrators Farshad Mohajeri Posted August 4, 2016 Administrators Posted August 4, 2016 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. Quote
leozem Posted August 4, 2016 Author Posted August 4, 2016 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. Quote
leozem Posted August 4, 2016 Author Posted August 4, 2016 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 Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.