Navision Database Size increasing very rapidly

amit.mbs

Hi

I had implemented navision 3.7 version with navision database to one of my client, problem is that database size is inreasing very rapidly, size is now more than 4GB, can any body tell is there any database tunning or optimization is available for navision database or what could be the reason why my database is increasing so fast, only my item ledger entry is having around 8 lac of record, with this size can my database can reached to 4GB, please let me know is there data compression facility is there.

Regards
Amit

kine

size growing is depending on: modules used, no of documents per day/week/month, no. of dimensions used, on customizations made, no. of charges posted per day/week... used costing method...

Marije_Brummel

You can see the size of each table in the database information/tables form.

The size of the database sould not realy be a problem unless you have performance issues.

You can compress old entries, but this means loosing detailed information.

You sould investigate which part of navision causes the growth.

kriki

kine wrote:

size growing is depending on: modules used, no of documents per day/week/month, no. of dimensions used, on customizations made, no. of charges posted per day/week... used costing method...

And also :
- number and size of fields in the tables.
- number and size of secondary indexes in the tables (eg. T32:"Item Ledger Entry" in W1 : about 2/3 of the total size for this table is for indexes, not the data)

randrews

It depends on Keys in big tables

We have 19GB database after 1 year of working.
So the size of base will 60 GB in next 2 Year.

suresh111

Do you store the picture of itmes in yr item card. I had this probelm. Now we show the picture, when you go out of the form it will be deleted.
suresh

Cristina

I have the same problem. But my scenarios is:

1. We are in retail bussines
2. A head quarters database on SQL and a native database on store
3. We used an add-on from Landsteinar Retail. For replication we used DataDirector (from Landsteinar Retail) and NAS
4. For 3 stores the databease arried on 100% use. We can expand the database and after expand the used space is on 90% but we can't do anything in database. If we closed the database and reopen the free space is 0
5. We've try the following: all services was stopped (NAS,DD and Navsion Server)

Have some an ideea why is happend this?

kine

One hint: Try to copy info from the Database - Informations - Tables (mainly the tables size) into excel. Close the DB, reopen and copy it again into excel - compare table sizes. You can found which table is the problem...