On Thu, Jan 26, 2012 at 18:42, Emmanuel Tabard <m...@webitup.fr> wrote: > > The thing is, the whole database takes 5go. That's why I was wondering how > the script can eat 20go of memory. Maybe sqlobject leaks !
Or maybe my script does. :P (by the way you can try using SQLAlchemy, instead, with the '-o sqlalchemy' option of imdbpy2sql.py - yes, we support two ORMs...) > To make it faster you can also generate a unique signature for each rows > (sha1(title, index, year, kinds)?). Index this field and your temp table > would be : imdbid | signature. > It should be quick. Yep, I was thinking at something like that. I'll try to see if the signature can be easily created when the data are first inserted. -- Davide Alberani <davide.alber...@gmail.com> [PGP KeyID: 0x465BFD47] http://www.mimante.net/ ------------------------------------------------------------------------------ Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 _______________________________________________ Imdbpy-devel mailing list Imdbpy-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
