-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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? Trse. - -- =================================================================== 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/ iEYEARECAAYFAk1nuhQACgkQ+gerLs4ltQ43PgCghmO5BM2qNznPdBUtuaoIcht8 v+QAn2usSMP84/K25Txl3sILWdtAV18y =UaLr -----END PGP SIGNATURE----- _______________________________________________ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
