On Apr 27, Davide Alberani <[EMAIL PROTECTED]> wrote: > Unfortunately (after a lot of work was already done, sigh!) we are > now facing a problem: performances (at insert-time only [1]).
In the meanwhile, I've tried various solutions and... I'm back in optimistic-mode! ;-) To make a long story short: it seems feasible to take the older version of imdbpy2sql.py (the one shipped with IMDbPY 2.4) and then: 1. integrate it with the code written by Giuseppe to use SQLObject, and my code to support tv series episodes. 2. extract the cursor object to run the executemany() method. 3. write a custom createSQLstr() function to build a suitable SQL string - even taking care of the various parameter styles. This would save both the work put in dbschema.py and also a lot of what was done imdbpy2sql.py. I can't guarantee that it will work under every circumstances and strange environment, but... From now on, I think that very few important issues are still open; maybe in 2 or 3 of weeks IMDbPY 2.5 can be out. :-) -- Davide Alberani <[EMAIL PROTECTED]> [PGP KeyID: 0x465BFD47] http://erlug.linux.it/~da/ ------------------------------------------------------- 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 _______________________________________________ Imdbpy-devel mailing list Imdbpy-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
