I need more information regarding --- I am trying to execute same query with different seelction criteria and want to find the response time for the different criteria given .
But when I check the response time noe for the first time if I execute the query if that showed me 3 sec second time ( with different selection criteria it shows me 9) means we have to deduct 9-3 sec isit.
or do we have any other option to get the exact response time when I execute the same query second time
If you use rsrt, select the query you want to run and click 'Execute and Debug'. On the debug options select 'display statistics data' and 'do not use cache'.
Run the query and get the results. Then click the back button. The 'statistics data for query run time' will appear, there is a colunm in there which states duration. Add the duration up and this will give you the total time of your query run time.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.