Message79050
Hopefully I'm not picking at a scab here. I updated the dbm.sqlite
module in the sandbox. It now orders by rowid instead of by key.
(I saw no performance penalty for the small table sizes I was using
to ordering. I switched from ordering by key to ordering by rowid
based on Gerhard's comment.
I got a big performance boost on writes by only committing once every
100 calls to __setitem__. I still commit when deleting keys and
explicitly commit when closing.
The main performance bottleneck now appears to be keys() and iterkeys().
I don't see how to make them any simpler. Oddly enough, it seems
that iterkeys() is slower than keys(). Maybe it's just lack of sleep
but I can't see why this is so. |
|
Date |
User |
Action |
Args |
2009-01-04 12:36:36 | skip.montanaro | set | recipients:
+ skip.montanaro, rhettinger, gregory.p.smith, jcea, ghaering, josiahcarlson, pitrou, erno, gregburd |
2009-01-04 12:36:35 | skip.montanaro | set | messageid: <1231072595.93.0.319441964239.issue3783@psf.upfronthosting.co.za> |
2009-01-04 12:36:35 | skip.montanaro | link | issue3783 messages |
2009-01-04 12:36:34 | skip.montanaro | create | |
|