"Paolo Pisati" <p.pis...@oltrelinux.com> wrote in message news:499a954e.5020...@oltrelinux.com > 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
