troubleshooting Question

How to debug DataSet performance

Avatar of netsmithcentral
netsmithcentralFlag for United States of America asked on
Web Development.NET ProgrammingASP.NETVisual Basic.NETMicrosoft SQL Server 2008
6 Comments1 Solution547 ViewsLast Modified:
I have a dataset in a Visual Studio 2010 Web App project which accesses the DB with a complex SQL statement.  If I run the statement in SQL Management studio directly, it loads in a less than a second.  If however, I run it using the "Preview Data" button in the dataset designer, or I try to access it on a page (with a gridview for example), it takes over 40 seconds!

What steps should I take to track down what's causing this huge delay when working with the dataset?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros