Any Ideas for Decreasing Table Replace Time?

matttrax
matttrax Member Posts: 2,309
edited 2008-06-18 in NAV/Navision Classic Client
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.
Matt Traxinger - ArcherPoint

Comments

  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,692
    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
    Slawek Guzek - www.yitron.co.uk
    Business Central, MS SQL Server, Wherescape RED;

Categories