[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Lob area's

  • Thread starter Thread starter bkozak
  • Start date Start date
Status
Not open for further replies.
B

bkozak

Guest
Thank you all for the information so far -- much appreciated. Here's the tabanalys for the Lob fields in question with a DB blocksize of 8K. Table LOBs Size Min Max Mean PUB.LOG:2 Data:5 3407748 1.7G 2.0B 2.6K 524.7B PUB.blobs:5 File:7 8258 1.5G 173.0B 19.5M 194.3K PUB.invoice-pdfs:4 invoice-pdf:6 282975 16.9G 102.0B 724.9K 62.7K Judging from these it looks like they shouldn't be 1 rpb, except for the first field. Doubt it would be worth it to separate them though...

Continue reading...
 
Status
Not open for further replies.
Back
Top