A multi-user system?

The_Taco

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

i4tost

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

Are you using MS SQL or Navision database server?

The_Taco

Ok thx, for the advice, ii'l check if it is a hardware issue. Peace!