-----BEGIN PGP SIGNED MESSAGE-----
On 02/25/2011 07:17 AM, Shane Hathaway wrote:
> Whereas FileStorage packs by creating a new copy of the database,
> RelStorage deletes individual rows. Unfortunately, SQL delete
> statements tend to be surprisingly expensive.
> To get closer to what FileStorage does, RelStorage could theoretically
> copy rows into new tables instead of deleting rows. I've pondered doing
> that, but it would take some major work, I think.
Maybe copying would be followed by truncating the original tables and
re-populating them via INSERT FROM?
Tres Seaver +1 540-429-0999 tsea...@palladion.com
Palladion Software "Excellence by Design" http://palladion.co
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
-----END PGP SIGNATURE-----
For more information about ZODB, see the ZODB Wiki:
ZODB-Dev mailing list - ZODB-Dev@zope.org