Any Ideas for Decreasing Table Replace Time?

matttrax

SQL Server 2000, Nav 3.7 upgrading to 5.0

As an example, G/L Entry table has 8 million records. Replacing this table with the 5.0 version takes probably 30 minutes since it redesigns and adds keys. I'm pretty sure Navision only allocated 1 CPU for the process, so even running on a faster computer would only give a marginal decrease in time.

Any other thoughts or ways to decrease this? It's an 80GB database, so I'm looking for any way possible to shave time off the upgrade process.

Thanks.

Slawek_Guzek

Hi,

NAV doesn't create keys 'on its own', only sends proper SQL command to SQL server. SQL server is responsible for creating all the indexes related to table keys.

Make SQL Server working faster - you will speed up replace table process.

Regards,
Slawek