Michael Bayer ha scritto:
> well at the very least you want to ensure that executemany() is being
> used for the inserts (i.e. with sqlalchemy, dont use ORM, use
> connection.execute(statement, [param, param, param...]).
>
> If you use SQLAlchemy's "executemany()" facilities, we've just
> increased their efficiency by about 60% in the 0.4.0beta3 release, we
> had some huge latency issues with this particular operation
> previously.
>
> faster still is to use raw DBAPI:
>
> conn = engine.connect()
> conn.connection.executemany(statement, [params...])
>
If this don't cause thread or other problem with SA, i think this is
the best solution, i can split my n insert query in segments of 100 qry
a time.
> using "copy from..file" is probably very fast, but its a little weird
> to use that in the context of a web request.
>
>
I think too...
Thank you
--
+------------------------------------------------------------+
Glauco Uri - Programmatore
glauco(at)allevatori.com
Sfera Carta Software(r) [EMAIL PROTECTED]
Via Bazzanese,69 Casalecchio di Reno(BO) - Tel. 051591054
+------------------------------------------------------------+
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
