"Paolo Pisati" <[email protected]> wrote in message news:[email protected] > I've a perl script that reads rows from a file, does some processing > and then insert the resulting data in a db, one INSERT per row. > Usually the input file is made of hundreds of thousands, thus a > typical run consists of hundreds of thousands of INSERTions. > > the performance was good until i decided to build indexes:
Try creating indexes at the end, after all the inserts are done. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
