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
_______________________________________________
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

Reply via email to