November 4, 2008 at 7:22 pm
I have a stored procedure we run from VB6 code using DSNless ODBC that ran fine through SQL Server 2000, but runs much slower in SQL Server 2005.
In Studio Manager, the query runs in ~30 seconds, but it takes ~3.5 minutes through MS SQL Server ODBC data provider.
Any idea why it would run so much slower via ODBC than via Studio Manager?
Thanks!!
November 4, 2008 at 9:40 pm
What ODBC provider/driver are you using?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
November 5, 2008 at 7:09 am
MS SQL Server ODBC 2.5.
Thanks!
November 5, 2008 at 7:47 am
Try the SQL Native Client instead.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
November 5, 2008 at 7:50 am
I normally would, but this application has a lot of code and this one issues was not identified by the users prior to going into production. A recompile and re-test of all pieces of the application would take a very long time.
I'm going to recommend using an index hint on the stored procedure that runs this query.
Thanks!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply