SQLDataSource and Query Speed

P

Paul

I have a .net 3.5 page with 10 SQLDataSources.

Does anyone know of an easy way to see how long it takes for each of the
queries to run?
 
C

Cowboy \(Gregory A. Beamer\)

Query alone?
Try Profiler if using SQL Server, as it will give the metric.

Complete time for each data source?
You will have to use code behind instead of declarative wiring (the drag and
drop/wizard approach) and wrap the actual data retrieval with a start and
stop time.

Hope this helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,776
Messages
2,569,603
Members
45,188
Latest member
Crypto TaxSoftware

Latest Threads

Top