Tuesday, August 31, 2010

SQLiteJDBC 5 row/s vs. CSV

Using SqliteJDBC v056, inserting around 3000 records into a SQlite table, no index, no trigger or any thing, just a plain table - and it took over 10 minutes to finish the job. Roughly 5 records per second.

Switched back to pure text file(CSV), 3000 records, it only took a couple of seconds.

No comments:

Post a Comment