55143681 Posted March 15, 2019 Share Posted March 15, 2019 In my project,I use UniQuery to query a table,when I set UniDBGrid's rows to 100,sometime it works abnormal,it does not give me all the data fastly,how to finish that? Link to comment Share on other sites More sharing options...
Sherzod Posted March 16, 2019 Share Posted March 16, 2019 On 3/15/2019 at 8:24 AM, 55143681 said: In my project,I use UniQuery to query a table,when I set UniDBGrid's rows to 100,sometime it works abnormal,it does not give me all the data fastly,how to finish that? How many columns are in the grid? Have you tried to get the execution time of a query outside of UniGUI? Link to comment Share on other sites More sharing options...
Abaksoft Posted March 16, 2019 Share Posted March 16, 2019 UniQuery.FetchAll:=False; UniDbGrid.webOptions.paged:=True; UniDbGrid.webOptions.PageSize:=100; Normally this take 100 ms even with 100 000 records !!! 1 Link to comment Share on other sites More sharing options...
mhmda Posted March 16, 2019 Share Posted March 16, 2019 I think it depends on the query itself: join, calculation, sub select etc. Extjs itself uses buffering in client-side like Android when using a listview. You can try to measure executing time for your query. 1 Link to comment Share on other sites More sharing options...
55143681 Posted March 20, 2019 Author Share Posted March 20, 2019 On 3/16/2019 at 11:06 PM, Sherzod said: How many columns are in the grid? Have you tried to get the execution time of a query outside of UniGUI? about 20 columns,the speed is very fast,but the result is abnormal,sometimes return 50 and sometimes return 80 and sometimes run normally Link to comment Share on other sites More sharing options...
adragan Posted March 22, 2019 Share Posted March 22, 2019 Speed of a query depends of a lot of things and I think the last one is UniGui. Run and optimize the query first from the administration console of the db server, Some DB engines load only a no of pages in memory and retrieve the rest only on demand. Try to check the processor load with users on if you can. That's only a few of the thing that can go wrong. In my case with 60 users connected and on a table in excess of 100 milion records an indexed search "paints" a result set of 216 records in less than 3 sec. So figure. Link to comment Share on other sites More sharing options...
55143681 Posted March 26, 2019 Author Share Posted March 26, 2019 when i set the page size to 25. ,run normal,but if i change the pagesize to 1000,then the problem comes out Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now