Re: Compression related performance

On Thu, 20 Jan 2005, Jim wrote:

> On Sat, 15 Jan 2005, Neal Richter wrote:
>
>> Question #1)
>> 
>>   Could you download a fresh copy of BDB 3.0.55 from
>> http://www.sleepycat.com/download/index.shtml
>> 
>> It's easy to build, I am most interested in the results when you run 
>> db_stat on the uncompressed files and report back the fill-factor.  This is 
>> a measure of wasted space in the BDB pages.  This won't work on the 
>> compressed index.
>
> How exactly do I obtain this information? In the entire package I see only
> one place that references fill-factor (diskspace.html) and all it says is
> that you can obtain it with db_stat. However I don't see anything called
> fill-factor in the db_stat output. What options are needed to extract this
> info? Or is it a value that needs to be computed from other output?

Jim:  The 'xx% ff' below is the 'fill factor'

db_stat -d db.words.db
53162   Btree magic number.
7       Btree version number.
Flags:
2       Minimum keys per-page.
1024    Underlying database page size.
4       Number of levels in the tree.
170348  Number of keys in the tree.
328     Number of tree internal pages.
109792  Number of bytes free in tree internal pages (67% ff).
7019    Number of tree leaf pages.
2541354 Number of bytes free in tree leaf pages (65% ff).
0       Number of tree duplicate pages.
0       Number of bytes free in tree duplicate pages (0% ff).
0       Number of tree overflow pages.
0       Number of bytes free in tree overflow pages (0% ff).
0       Number of pages on the free list.


Thanks

-- 
Neal Richter 
Knowledgebase Developer
RightNow Technologies, Inc.
Customer Service for Every Web Site
Office: 406-522-1485



-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
Tool for open source databases. Create drag-&-drop reports. Save time
by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
Download a FREE copy at http://www.intelliview.com/go/osdn_nl
_______________________________________________
ht://Dig Developer mailing list:
[email protected]
List information (subscribe/unsubscribe, etc.)
https://lists.sourceforge.net/lists/listinfo/htdig-dev