On 8/18/07, Davide Alberani <[EMAIL PROTECTED]> wrote: > On Aug 18, Vetle Roeim <[EMAIL PROTECTED]> wrote: > > > Hi Davide, > > Hi! > > > I searched around a bit, and it seems that it is recommended that > > the indexes are added before inserting data, > > Yup: it's done to improve performances; the imdbpy2sql.py script > already does that: first it inserts every item in the database and > then it builds the indexes. Unfortunately, using InnoDB, this last > step is way too slow (for some reason I can't figure out).
I think you misunderstood me, it's recommended to add the indexes _before_ adding the data. So, 1) create table, 2) add indexes, 3) insert every item in the database. That will supposedly be faster than 1) creating table, 2) inserting every item, 3) building indexes. > Anyway, I'm still wondering if the best solution is to support the > InnoDB tables in the code or just explain in the documentation how to > convert a MyISAM database to InnoDB. > > Everyone can consider the above paragraph a poll. :-) Supporting innodb: 1 vote from me ;) Unfortunately it might not be that easy with sqlobject, I guess. [...] -- Vetle Roeim ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Imdbpy-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
