Skip to Content
Former Member
Dec 11, 2007 at 08:43 PM

Large Database Size



One of our clients has been running B1 for about two years now with a monthly load of 2000-3000 document cycles (that would be 3000 of each SO, DN, IN and IncPmts).

The database is now a healthy 18GB file.

The files are distributed as 200MB on each document header table (OINV, ORDR, etc) and 2GB on each line level table (INV1, RDR1 etc). The ADOC is about 1GB and the ADO1 is about 5GB.

I imagine the DB will only keep growing, possibly slowing down operations and reporting in a couple of years from now, not to mention of copying the DB to support if anything breaks...

Do you know of any recommendations for database maintenance?

Have you seen any documentation on this topic on the partner portal?

Thank you!