title: Python and sqlite3 - adding thousands of rows
body: <p>I have a .sql file containing thousands of individual insert statements.  It takes forever to do them all.  I am trying to figure out a way to do this more efficiently.  In python the sqlite3 library can't do things like ".read" or ".import" but executescript is too slow for that many inserts.  </p>
  
  <p>I installed the sqlite3.exe shell in hopes of using ".read" or ".import" but I can't quite figure out how to use it.  Running it through django in eclipse doesn't work because it expects the database to be at the root of my C drive which seems silly.  Running it through the command line doesn't work because it can't find my database file (unless I'm doing something wrong)</p>
  
  <p>Any tips?</p>
  
  <p>Thanks!</p>