[NOTE: for some very good reason, it seems that this message is
disappeared from the list of pending requests; maybe the mailman
switching of sf.net is still causing some troubles]
Anyway, regarding your message: that's a very good news! :-)
I've tested, and it seems to work even for MySQL - it's clear that
some weeks ago I've done something wrong, trying to add the indexes.
After all, maybe that SQLObject can be used for this task. :-)
It would be really cool (but this is not a show-stopper issue) if
the 'id' column can be removed/not created, when it's not needed.
The executemany issue, I fear, can't be solved neither with SQLObject
or SQLAlchemy; with both - if we care about performances - we have to
extract a cursors and run its executemany method (handling manually
the different parameters styles)
----- Forwarded message from Corbelli Giuseppe <cowo@...> -----
Subject: Re: [Imdbpy-devel] we got tests
From: "Corbelli Giuseppe" <cowo@...>
To: Davide Alberani <alberanid@...>,
IMDbPY support and development <imdbpy-devel@...>
Date: Thu, 1 Jun 2006 11:17:43 +0200
On Wed, May 31, 2006 at 03:05:45PM +0200, Davide Alberani wrote:
> Conclusion: what we really need is to decouple insertion of the data
> and generation of the indexes.
> Notice that, when indexes are updated for every insert, the insert
> time grows exponentially: the test run for only 100 cycles, but the
> real data will require _500_ rounds!
> Now my question is: does SQLObject _really_ not support creation of
> indexes _after_ that the data is in the table?
> Some weeks ago I've tried, but maybe I've missed something.
I've managed to create a new index at runtime using SQLObject 0.7
col1 = UnicodeCol()
col2 = UnicodeCol()
TableX.sqlmeta.addIndex(DatabaseIndex('col1', 'col2', name="testIndex"))
Tested with postgresql.
So it seems we can go on with SQLObject. The only trouble left is the
Giuseppe "Cowo" Corbelli ~\/~ My software: http://cowo.yoda2000.net
-<! Take It All, Our Gold, Our Homes, Our Life,
But We Didn't Kill Your Christ! !>-
Blind Guardian - The Script For My Requiem
----- End forwarded message -----
Davide Alberani <alberanid@...> [PGP KeyID: 0x465BFD47]