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,781
Messages
2,569,615
Members
45,295
Latest member
EmilG1510

Latest Threads

Top