On Mon, May 08, 2006 at 06:10:14PM -0300, Flavio Coelho wrote:
> HI, I have a similar problem of absurdly slow sql inserts on SQLite.
> 
> I the solution you propose (more specifically the second one), where  do I
> call commit() ata the end of the insertion process? can I call it On the
> class._connection, like below?
> 
> Test._connection.commit()

   No, I thing it should be something like this (untested):

transaction = Test._connection.transaction()
transaction.query(transaction.sqlrepr(Insert(...))) # transaction is a kind of 
connection
transaction.commit()

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            [EMAIL PROTECTED]
           Programmers don't die, they just GOSUB without RETURN.


-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to