A multi-user system?

The_Taco
The_Taco Member Posts: 6
edited 2004-07-23 in Navision Attain
Hey guys, I've got a little but important question if anyone knows..

I work for a company that has just merge from an old system, wich is As400, to Navision. Navision works well, and offer lots of opportunities but there is a glitch, the software seems kinda slow and I think we know what is the cause, and I'm asking you...

There is about 1500 employees who works for this company, so you can imagine that the system contains lots data in it.

The thing that seems to slow Navision down, it's when we report things like invoices, well anything that require changes in a table. Navision locks the table that is requested every time we update, create or delete data.

Is there any other ways to speed up the system a little bit like LOCKING A RECORD instead of locking the entire table?

And I must mention that there is others software who use the same table that Navision use. Every time we request something from a table that Navision as already locked, things are getting pretty slow...

Any help would be greatly appreciated!

BTW, we are using Navison 3.1.0
You love me, I love you.

Comments

  • i4tost
    i4tost Member Posts: 208
    There is a lot of features to speed up Navision. One of them is Navision Application Server, which you can use to speed up posting and a lot of other operations.
    Very important, what database you are using. Let say, if you are using SQL database, it is very important to manage correctly SumIndexFields, because it goes to performance issues if you not managing them correctly (have too much)
    As i understood, you are using Navision Server database, so it works pretty good. I thing you have a problem with your hardware. Maybe you are using not perfect RAID. Let say if you are doing a lot of changes in the database, RAID 5 is not the best solution. Maybe some changes in standard database caused you a problems...
    For more information contact the company which implemented Navision.
  • kine
    kine Member Posts: 12,562
    Are you using MS SQL or Navision database server?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • The_Taco
    The_Taco Member Posts: 6
    Ok thx, for the advice, ii'l check if it is a hardware issue. Peace!
    You love me, I love you.

Categories