3 messages in com.googlegroups.sqlalchemy[sqlalchemy] large amount of insert
FromSent OnAttachments
sdob...@sistechnology.com17 Aug 2007 01:12 
Glauco17 Aug 2007 01:28 
Michael Bayer17 Aug 2007 08:31 
Subject:[sqlalchemy] large amount of insert
From:Glauco (gla@sferacarta.com)
Date:08/17/2007 01:28:11 AM
List:com.googlegroups.sqlalchemy

What's is the best solution for a web procedure , in TurboGear, that produce a large amount of insert into ? (from 2000 to 20000 insertions on a submit)

i've done some try with somethink like 5000 insertion and the transaction is huge....

do you think sqlalchemy can do this better with some trick or is better to transfer all data in a " copy from .... " file?

Sfera Carta Software(r) in@sferacarta.com Via Bazzanese,69 Casalecchio di Reno(BO) - Tel. 051591054 +------------------------------------------------------------+