On Tue, Sep 10, 2013 at 1:41 AM, Sawyer Ward <warriorsw...@gmail.com> wrote:
>
> am currently trying to import the IMDb database on Ubuntu 12.04 server using
> the following command:
>
>  imdbpy2sql.py  -d text_imdb/ -u 'mysql://root:xxxxxxx@localhost/imdb' -o
> sqlalchemy --mysql-force-myisam
>
> While it's running, it says "FLUSHING MoviesCache" after every ten movies
> that are scanned. It sits at this message for a few minutes before it
> continues. Why is it hanging on this command?

Should not stop every 10 movies; if you see lines like:
  SCANNING movies: Title of a Movie (movieID: nr)

it's printed once every 10.000 titles.  So it's not that slow. :-)

The script basically scans a lot of titles (and other information)
keeping them in memory until they're periodically written to
the database.
For the movies, the batch is written every 100.000 titles (if the
write to the db fails, the data set is splitted in two halves, and
a warning is logged).

Has the script completed, on your system?  How long did it take?


-- 
Davide Alberani <davide.alber...@gmail.com>  [PGP KeyID: 0x465BFD47]
http://www.mimante.net/

------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13. 
http://pubads.g.doubleclick.net/gampad/clk?id=64545871&iu=/4140/ostg.clktrk
_______________________________________________
Imdbpy-help mailing list
Imdbpy-help@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-help

Reply via email to