[ZODB-Dev] Large ZODB packing and progress

[Tres Seaver]

-----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          tseaver at 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-----