topic Re: How to test speed with SQL query in Application Development and Automation Discussions

How to test speed with SQL query

1190_5939_439 — Thu, 07 Jan 2021 07:00:23 GMT

Hi Expert

The runtime is 30.547. I am not sure the speed is fast or slowly? Can you help me ?

Re: How to test speed with SQL query

Patrick_vN — Thu, 07 Jan 2021 08:47:00 GMT

At first glance, having to wait around 30 secs for 480 records, doesn't feel fast. But I have no idea what is in these custom tables you're using (are you selecting on key fields, how many records are in the tables,..etc). Which makes it kinda hard to give solid advice.

Could you maybe indicate why you ask the question? Is there a problem of some sorts?

Re: How to test speed with SQL query

MateuszAdamus — Thu, 07 Jan 2021 09:05:56 GMT

Hello

You need to provide at least basic information about the tables you're selecting data from (like Primary Key, possible indices?). Otherwise it's hard to give any advice.

Also, SQL query execution plan would be nice to look at.

Kind regards,

Mateusz

Re: How to test speed with SQL query

former_member660513 — Thu, 07 Jan 2021 09:55:41 GMT

Also how do you measure? What is the logic behind that custom report, and did you do a measurement with an official tool - ST05?

Re: How to test speed with SQL query

Sandra_Rossi — Thu, 07 Jan 2021 14:58:15 GMT

And also what database software do you use? (and as Mateusz said, please provide the Execution Plan)