How to increase the data query speed

[55143681]

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?

[Sherzod]

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?

[Abaksoft]

UniQuery.FetchAll:=False;

UniDbGrid.webOptions.paged:=True;

UniDbGrid.webOptions.PageSize:=100;

Normally this take 100 ms even with 100 000 records !!!

 

 

 

[mhmda]

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.

[55143681]

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

[adragan]

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.

 

[55143681]

when i set the page size to 25. ，run normal，but if i change the pagesize to 1000,then the problem comes out