[Imdbpy-devel] [sql] memory consumption

2012-01-26 Thread Emmanuel Tabard
hi, First of all, thank you for imdbpy. This is really plug'n play, well done !!! Context : - Import all imdb database (from text dumps) - first time it's fast and ok - I have the imdb ids for 90% of titles and names (no need for companies and characters) - I'll pay imdb for using those datas

Re: [Imdbpy-devel] [sql] memory consumption

2012-02-06 Thread Emmanuel Tabard
Alberani a écrit : On Thu, Jan 26, 2012 at 18:50, Emmanuel Tabard m...@webitup.fr wrote: # TIME FINAL : 1223min, 59sec (wall) 1095min, 16sec (user) 13min, 7sec (system) :-) You can notice that : - title 84% success - name 99% success For sure movie titles change more and faster than

Re: [Imdbpy-devel] [sql] memory consumption

2012-02-12 Thread Emmanuel Tabard
to restore. Should be freaking fast ... Le 12 févr. 2012 à 14:56, Davide Alberani a écrit : On Sun, Feb 12, 2012 at 14:20, Emmanuel Tabard m...@webitup.fr wrote: Fair enough ! When it was selecting all the not null ids, the memory of the process grows up and the size of the .db never grows up. My

Re: [Imdbpy-devel] [sql] memory consumption

2012-02-12 Thread Emmanuel Tabard
= title_extract.imdb_id -- Restore imdb ids for people (5min) UPDATE name INNER JOIN name_extract USING (md5sum) SET name.imdb_id = name_extract.imdb_id Total time save/restore : less than 10minutes Le 12 févr. 2012 à 15:52, Emmanuel Tabard a écrit : I was wondering, why don't you use the original dbs

Re: [Imdbpy-devel] [sql] memory consumption

2012-02-12 Thread Emmanuel Tabard
are over ! Thanks you very much for your help ;-) Le 12 févr. 2012 à 19:23, Davide Alberani a écrit : On Sun, Feb 12, 2012 at 16:50, Emmanuel Tabard m...@webitup.fr wrote: Here is a little workarround : Well, that's a very interesting solution, thanks. :-) Anyway, I have to think

Re: [Imdbpy-devel] [sql] memory consumption

2012-02-20 Thread Emmanuel Tabard
: 1min, 19sec (wall) 0min, 0sec (user) 0min, 0sec (system) Freaking fast thank you for those quick fixs ! Also, thanks for the credits ;-) Le 19 févr. 2012 à 11:26, Davide Alberani a écrit : On Sun, Feb 12, 2012 at 21:17, Emmanuel Tabard m...@webitup.fr wrote: Well, that's a very