[ZODB-Dev] Re: Relstorage: Slow packing with Mysql when GC is turned on

[Anton Stonor]

Hi Shane,

> The bug comments suggest wrapping the subquery in "select * from (...)" 
> to materialize the subquery only once.  I've attached a patch that does 
> that.  Let me know whether it helps or hurts.  Note that this isn't the 
> final form of the patch since the other supported databases don't need 
> this hack, but if it helps, I'll apply it to the MySQL adapter only.


Excellent! Prepack now takes a few minutes instead of hours.

The patch triggered this Mysql error: "Every derived table must have its 
own alias", so I adjusted it a bit (attached).


/Anton
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mysql-rs-hack.diff
Type: text/x-diff
Size: 581 bytes
Desc: not available
Url : http://mail.zope.org/pipermail/zodb-dev/attachments/20080527/e5f7484e/mysql-rs-hack.bin