leozem Posted August 2, 2016 Share 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 Link to comment Share on other sites More sharing options...
stas Posted August 2, 2016 Share Posted August 2, 2016 You can emulate UniDbgrid Page Mode for example select first [PageCount] skip [PageCount]*[NPage-1] B.* FROM BIGTABLE B Quote Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted August 2, 2016 Administrators Share Posted August 2, 2016 Please specify your uniGUI version. Quote Link to comment Share on other sites More sharing options...
leozem Posted August 3, 2016 Author Share Posted August 3, 2016 0.99.80.1249, 0.99.95.1309 The two versions have the same problem. Quote Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted August 3, 2016 Administrators Share Posted August 3, 2016 0.99.80.1249, 0.99.95.1309 The two versions have the same problem. Trial edition? Quote Link to comment Share on other sites More sharing options...
leozem Posted August 3, 2016 Author Share Posted August 3, 2016 yes Quote Link to comment Share on other sites More sharing options...
leozem Posted August 4, 2016 Author Share Posted August 4, 2016 Is there a way to solve it? Quote Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted August 4, 2016 Administrators Share 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 Link to comment Share on other sites More sharing options...
leozem Posted August 4, 2016 Author Share 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 Link to comment Share on other sites More sharing options...
leozem Posted August 4, 2016 Author Share 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 Link to comment Share on other sites More sharing options...
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.