On Thu, Apr 12, 2012 at 12:03, darklow <dark...@gmail.com> wrote: > > Would it be possible to improve imdbpy2sql script so that episodes > production_year field contains correct episode year, which is calculated by > episode movie_info release date? > > I am not sure how episode production year is calculated, but it is wrong > and incomplete for almost every TV show.
Hi! Hmmm... never noticed it. :-/ Unfortunately it really seems that the data in the plain text data files are unreliable, on this. From movies.list.gz: "House M.D." (2004) {Dying Changes Everything (#5.1)} 2004 Which doesn't make much sense, for: http://www.imdb.com/title/tt1274484/ (and it's not even that every episode use the year of the first season... :-/ ) I fear there's not much that can be easily done in imdbpy2sql.py, but I'll have a look. Maybe you can speed up your stored procedure adding some indexes (on title.episode_of_id, perhaps), but I'm not sure. Thanks for the report! -- Davide Alberani <davide.alber...@gmail.com> [PGP KeyID: 0x465BFD47] http://www.mimante.net/ ------------------------------------------------------------------------------ For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 _______________________________________________ Imdbpy-devel mailing list Imdbpy-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-devel