Works like a charm. Thank you!
Ladislav Lenart
> On Sep 10, 2012, at 10:53 AM, Ladislav Lenart wrote:
>
> > Hello.
> >
> > Is there any performance (plus communication) difference between
> >
> > # bulk insert of several rows
> > new_rows = []
> > for i in range(10):
> > new_rows.append({'foo': i, 'bar': i})
> > cls.__table__.insert().execute(new_rows)
> >
> > and
> >
> > for i in range(10):
> > ins = cls.__table__.insert().values({
> > 'foo': i,
> > 'bar': i
> > })
> > session.execute(ins)
> >
> > I guess there is. If so, can the second example be written more efficiently
> > (but
> > still using session)?
>
>
> use this style please:
>
> new_rows = [{"foo":i, "bar":i} for i in range(10)]
> session.execute(ins, new_rows)
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
