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?
.NET ProgrammingMicrosoft SQL Server 2008Visual Basic.NETASP.NETWeb Development
Jacques Bourgeois (James Burger)
8/22/2022 - Mon
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!