> So, if you truly want DBAPI-speed inserts, use the raw connection:
>
> engine.connect().connection.executemany("your statement", [{params1},
> {params2}, {params3}, ...])
>
>
>
Wow.. after some try i found this is enought fast for me..
engine.connect().execute(sql,list_qry_params )
direct execution of a precompiled sql throw a list of 3000 dict is
faster about 12 times!!
Main interesting feature is occupation of CPU and memory .. it is lesser
than an half of previous method ( n x single row insertion )
thank's Michael for your help
Glauco
--
+------------------------------------------------------------+
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 sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
