Options

Improve performance on a Navison SQL

QVIXOTEQVIXOTE Member Posts: 3
Hi!
Somebody knows how to improve performance on a Navison SQL database using archive groups for tables and indexes?

Thanks![/b]
...vámonos poco a poco, pues ya en los nidos de antaño no hay pájaros hogaño: yo fui loco, y ya soy cuerdo.

Comments

  • Options
    PaddyMullaneyPaddyMullaney Member Posts: 59
    With indexes, the best way is to re-index regularly. I am not sure what archive groups are.

    There is a document on Partnersource called "Performance Troubleshotting Guide for MBS Navision", whih deals with performance on SQL in general and ways to get it working better. It is pretty good.

    If you have trouble finding it, let me know yur email address and I will mail you a copy if you like.

    Paddy
  • Options
    QVIXOTEQVIXOTE Member Posts: 3
    Thanks.
    I have this guide too.
    ...vámonos poco a poco, pues ya en los nidos de antaño no hay pájaros hogaño: yo fui loco, y ya soy cuerdo.
Sign In or Register to comment.