Sales Line Table (37) Record Size Table Size

slowhandfan

I have a customer running Nav 4.02. They have a large database running under SQL (394 Gig).

When I do FILE DATABASE INFORMATION TABLES, it shows that the sales line table(37) has

No. of Records 281370 (believable number, 80 stores for 4-5 days) ,
Record Size 93,911
Size(KB) 25804376 (That is 25 gig)

How can a relatively small record that should be able to easily fit in 1/2 gig, have a record size of nearly 100,000 and take up 25 gig???

Has anyone else encountered this problem with the Sales Line Table, and do you have any suggestions?

Modifications to this table have been minimal

Thanks

Scott aka SLOWHANDFAN

SPost29

Our salesline table's record size is 2862 with many many mods.
Our total DB is 93 gig.
That may help with some perspective.
Steve

kriki

-no rebuild index done. or low fill factor.
-lots of big indexes and lots of flowfields and all buckets are kept.

Alex_Chow

BLOBs?

Also, maybe too many keys created on that table.

kine

Yes, do not forget that there is some max record size in NAV. Thus rest of the size is overhead like indexes or Blobs. If you have 20 keys on the table, with many fields...