Help on retrieveing query result time ???

[Guest]

Dear all,

I have build an ASP.net application which calls different store procedure.
When my customer request datga from store procedure, I would like to display
on the page, the time it takes to return data.

How to do that ?

regards
serge

 

[William \(Bill\) Vaughn]

Ah, you could generate at time delta (GetDate()) and return it as an output
Parameter but this would not really give an accurate representation of how
long it takes to "return" the data. Much of the time is used up serializing
the data to TDS and back again on the client. You would also not see this
OUTPUT parameter until all the rows had arrived. By then you could have
built a client-side timer to measure the operation time.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________