Discussion Locked

SQL Server 6 to 7

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am running a 16-bit VB application to feed data into a SQL 6 database. We want to upgrade the database to v7.0, and this was achieved on an identical machine.
When they run side by side with the same data to be inputted, the SQL 7 operation takes1.5 times longer than the SQL 6.
Does anyone have any ideas why?

5 replies

by rmmcp

This is most likely a result of the setup options that were used for the migration to SQL 7. The more complex character sets, code, etc... that is used the longer an update will take. Make sure that the 7.0 setup is not using "case sensitive" for a sort order. That's a big hit on speed. Also, take into consideration the network connection that is being used or if the database update is done from the SQL host machine.

by rsutton

Something to check would be the compatability level.

run:
sp_dbcmptlevel "DB_NAME_HERE" w/o the quotes!
To see what it is set to. By default it stays at version 6 or 6.5. SEE BOL and search on "sp_dbcmptlevel"!!

Good Luck !!

This discussion is closed to new replies.