General discussion

Locked

SQL Server 6 to 7

By Steven666 ·
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?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL Server 6 to 7

by RMmcp In reply to SQL Server 6 to 7

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.

Collapse -

SQL Server 6 to 7

by Steven666 In reply to SQL Server 6 to 7

The question was auto-closed by TechRepublic

Collapse -

SQL Server 6 to 7

by rsutton In reply to SQL Server 6 to 7

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 !!

Collapse -

SQL Server 6 to 7

by Steven666 In reply to SQL Server 6 to 7

The question was auto-closed by TechRepublic

Collapse -

SQL Server 6 to 7

by Steven666 In reply to SQL Server 6 to 7

This question was auto closed due to inactivity

Back to Networks Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums