* Patrick K. O'Brien wrote on [2007-09-13 12:45:24 -0500]:
> What I'd be curious to know is how quickly does
> ShelfStorage startup time degrade in between packings? I'm hoping that the
> benefits of ShelfStorage don't degrade too quickly (like, startup time
> increasing dramatically after only a few transactions without a pack).
> Does anyone have any insight into this?
Ok, I'll bite -- herein are the results of growing a ShelfStorage
that has been packed but no other new object activity as yet --
adding new objects in batches of 5,000 to my collection of 500,000
"NewsItem" objects:
Commit New Startup Diff
(get root)
Baseline n/a 0.001 0.000
5,000 5.394 0.185 0.184
5,000 5.540 0.364 0.179
5,000 5.813 0.556 0.192
5,000 5.924 0.736 0.180
5,000 6.080 0.918 0.182
Pretty linear.
I then did a pack; comparing it to the original bulk load and pack:
Seconds RAM Consumed (peak)
Initial 500,000 247 74MB
Subsequent 25,000 332 10MB
Adding another few sets of 5,000 records and re-running the timing
tests produced results very much in line with those listed in the
first table.