I did
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 <phd@???>:
>
> 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/ phd@???
> 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
> sqlobject-discuss@???
> 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
