November 9, 2007 at 7:37 am
Hi. I've recently migrated a database from SQL Server 2000 to SQL Server 2005. Most things seems to be fine except that I'm getting a problem retrieving data from Views via ADO and KeySet cursors in a legacy (VB6) app. The problem is that it is taking considerably longer to retrieve data from the view on the migrated database than it did for the same view on the pre-migration 2000 database - 82 seconds and 5 seconds respectively!! Somewhat puzzled as to why this should be.
I've rebuilt all the indexes on the database but to no avail. So I was wondering if anyone could shed some light on this and possibly suggest a solution?
Regards,
YaHozna.
November 9, 2007 at 10:23 am
the compiler is probably picking a different execution plan than it was previously.
I would start there.
November 9, 2007 at 11:40 am
Did you update statistics on all tables / indexes after migration ?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply