August 14, 2009 at 4:57 am
Hi 🙂
I have a vb.net project that I have been working on for a year. Everything was working fine until last week. When I fired up the project, one of the vb projects has disappeared so I had to revert to a previous solution file from a backup.
Since then (I think) the link to SQL Server has really slowed down. If I run a given sql statement within a dataset in VS it takes 10 seconds - the exact same SQL run from managmenet studio executes within a second. This is similar for any data operation.
I've checked references against another recent project which is running fine and they are the same.
Any help would be appreciated
Many thanks
Tim 🙂
August 17, 2009 at 7:01 am
What I would suggest as a first step is to use profiler and check if the query is really executing within the same amount of time as SSMS do and check the parameters! You might think the application is passing some parameters but it might be slightly different (code not found yet or obscure section of code in .Net that changed them before the call)
That check will be a good starting point.
After that there's latency, authentication, project compilation (debug mode), connection string settings and so on.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply