database is to slow...what can i do??

Trint

it is 2.5 gigs and we have several larger ones that are much faster...database is to slow...what can i do?? is there some kind of optimization tool??
thanks,
Trint

eromein

yes, there is a tool. But it's not fully automatic.

Note: This slow database is coursed be sloppy and bad programming. Please keep in mind that programming is all about he speed of the system. So don't forget to think about keys, setcurrentkeys, smart flowfields, loops, etc...

You have to use the client monitor. Activate the client monitor (Tools, Client Monitor, Start) close the window and go doing slow stuff. Open windows that are slow, create records, post orders, run report... every thing that is slow.

Stop the client monitor (Tools, Client monitor, stop) and find you problems like this:

Set a 'Records Read' filter on the column 'parameter'
Set a filter on the number column bigger than 10. (for starters) If you have a lot of higher numbers increase the value of the filter. Optiomal record read should be 2. But Navision's poloicy says that 10 is normal.

If you found a problem in record reads, select the record in the client monitor and delete the filter you placed. Noe set a filter on the entrie no with the same value the client monitor record. You will see the complete action Navision did that coursed the problem.

FIX IT!

Do this untill you have a fast database.

Frank_Hulsbosch

We've also had a problem of slowliness with our database (of 21 Gb).

The solution consisted of 2 things to change :

a) at that moment we replicated about 200000 records towards our web-site (at first without any COMMIT statements and thus blocking people from changing the data because the table was locked for a long time)

b) we added 1 Gb of memory to our Navision server and increased the cache size on the server by changing the Navision Service settings

eg.
server Installasservice,servername=<servername>02,cache=920000,commitcache=Yes,Database=<database location and name>

Wayne

There is a report in Attain 3.6.
ID Nr. 50007. The report checks if your
database server is to busy.
Permanent database check.

Maybe you have to split the database in several
parts on different Harddisks. Check also if the harddisks
are fast enough: At least 10.000 U/min.