[ZODB-Dev] How expensive are savepoints?
Christian Heimes
christian at cheimes.de
Sat Jul 9 09:09:08 EDT 2005
How expensive and costly are savepoints? I wasn't able to find
informations about it in the Zope docs. Are they as expensive as sub
transactions or are they just using some CPU cycles?
I'm thinking about using savepoints in my migration code. The code is
migrating a possible large amount of objects (hundreds up the tenth of
thousands). I don't want the code to fail because the last object has an
unicode decode issue.
Code example:
for ob in objs:
savepoint = transaction.savepoint()
try:
migrate(ob)
except ConflictError:
raise
except:
log()
savepoint.rollback()
If savepoints are costly I would create a new savepoint every 10 or 50
objets.
Christian
More information about the ZODB-Dev
mailing list