[storm] execute many?
James Henstridge
james at jamesh.id.au
Mon Apr 14 10:05:00 BST 2008
On 11/04/2008, Gustavo Niemeyer <gustavo at niemeyer.net> wrote:
>
> > Unless I am mistaken (it is not documented) the execute method is
> > autmatically committed? If not that would be a good thing as the whole
> > update process would then be journaled and not stored.
>
> Statements run with execute() are inside the same transaction as every
> other action done by the ORM-specific portions.
It is also worth noting that for PostgreSQL and MySQL, executemany()
effectively just calls execute() multiple times.
You should definitely only think of it as a performance improvement
rather than something to give you additional transactional integrity.
James.
More information about the storm
mailing list