How to time duration of a query?

[binain]

I am trying to figure out the amount of time some of my queries take to run, and I was hoping to write a function that would simply "run" each query once or a number of times and calculate the average run time. However, the Execute functionality only works on Action queries - I can't think of any way to time get the query to run multiple times.

Does anyone have any suggestions for getting a decent time estimate for a select query?

 

[Guest_imported]

Hmmm - there was a good and valid reply here earlier - I wonder why it was censored?