connection = connectionForURI(connection_string)
sqlhub.processConnection = connection.transaction()
and the I called:
Test._connection.commit()
where Test is the class.
It worked. Now the insertion process is faster, but still much slower that the same operation using MySQL. Any hints to further speed up this transaction?
Thanks,
Flávio
2006/5/8, Oleg Broytmann <[EMAIL PROTECTED]>:
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
--
Flávio Codeço Coelho
registered Linux user # 386432
---------------------------
"Laws are like sausages. It's better not to see them being made."
Otto von Bismark
