[ZODB-Dev] RelStorage - zodbconvert script and the --clear flag

Darryl Dixon - Winterhouse Consulting darryl.dixon at winterhouseconsulting.com
Wed Aug 31 16:20:32 EST 2011


Hi Folks,

Just had a quick query from my friendly local DBA; he wanted to know why
--clear was using DELETE rather than TRUNCATE; his comments were along the
lines of:
* TRUNCATE creates no UNDO
* TRUNCATE cleans out the indexes nicer

Is there any real downside or gotcha I should be aware of to following
this suggestion in this instance?

regards,
Darryl Dixon
Winterhouse Consulting Ltd
http://www.winterhouseconsulting.com


More information about the ZODB-Dev mailing list