Re: [SQLObject] Speed comparison

2010-04-01 Thread Juan Manuel Santos
(grr it happened again >.<, my apologies to the guy who received this mail, it was intended for the list) From: Petr Jakeš To: vicariou...@gmail.com Date: Thursday 01 April 2010 > Some examples of the code, so we all can learn from your experiences, will > be nice. > > Regards > > Petr > Wel

Re: [SQLObject] Speed comparison

2010-04-01 Thread Petr Jakeš
Some examples of the code, so we all can learn from your experiences, will be nice. Regards Petr On 1 April 2010 21:30, Juan Manuel Santos wrote: > I believe I fixed the speed issue. I wrapped the most expensive > functions/calls to SQLObject (expensive in terms of I/O) in a transaction. > I >

Re: [SQLObject] Speed comparison

2010-04-01 Thread Juan Manuel Santos
I believe I fixed the speed issue. I wrapped the most expensive functions/calls to SQLObject (expensive in terms of I/O) in a transaction. I didn't realize that that's the way SQLAlchemy works, and maybe that's why it was being faster (I had some functions which modified several attributes one

Re: [SQLObject] Speed comparison

2010-03-23 Thread Simon Cross
On Tue, Mar 23, 2010 at 7:50 AM, Juan Manuel Santos wrote: > Sorry, missed that detail. In all cases I used SQLite, with pysqlite at > version 2.5.6. > Python is version 2.6.4 Without actual source snippets to look at it's hard to say anything for certain but: Inserting records one at a time int

Re: [SQLObject] Speed comparison

2010-03-22 Thread Juan Manuel Santos
Sorry, missed that detail. In all cases I used SQLite, with pysqlite at version 2.5.6. Python is version 2.6.4 Cheers Juan Manuel From: Simon Cross To: sqlobject-discuss@lists.sourceforge.net Date: Tuesday 23 March 2010 > On Tue, Mar 23, 2010 at 5:57 AM, Juan Manuel Santos > > wrote: > > SQL

Re: [SQLObject] Speed comparison

2010-03-22 Thread Juan Manuel Santos
Sorry, missed that detail. In all cases I used SQLite, with pysqlite at version 2.5.6. Python is version 2.6.4 Cheers Juan Manuel From: Simon Cross To: sqlobject-discuss@lists.sourceforge.net Date: Tuesday 23 March 2010 > On Tue, Mar 23, 2010 at 5:57 AM, Juan Manuel Santos > > wrote: > > SQL

Re: [SQLObject] Speed comparison

2010-03-22 Thread Simon Cross
On Tue, Mar 23, 2010 at 5:57 AM, Juan Manuel Santos wrote: > SQLObject: > Text files: > real    0m25.704s > user    0m3.240s > sys     0m1.424s > SQLAlchemy/Elixir: > Text files: > real    0m13.754s > user    0m6.696s > sys     0m0.504s Which database backend are you using? Schiavo Simon -

[SQLObject] Speed comparison

2010-03-22 Thread Juan Manuel Santos
Hi everybody, First of all, before anybody attacks me, I do not intend to start a flamewar. I have simply been testing out SQLObject and SQLAlchemy/Elixir for a program I'm writing (I previously posted on some issues I had). If I am to be honest, I like SQLObject a lot more, because its syntax