This is what I did the last time I ran into SQLite being slow with inserts. I just shat out a CSV file and then imported it. It was much quicker! (like 1000x f

This is what I did the last time I ran into SQLite being slow with inserts. I just shat out a CSV file and then imported it. It was much quicker! (like 1000x faster) This article has some useful notes for me now to try the next time I play with my pet projects. :)