Jump to content

How to increase the data query speed


55143681

Recommended Posts

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

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.

  • Like 1
Link to comment
Share on other sites

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

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

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
×
×
  • Create New...