SQLite Forum

Fast way to insert rows in SQLite
This is such a great and clever idea! How come I didn't think of this! 

So, I took my best performing code, just updated the file path to `:memory:`. It took almost same time:

    33.08 real
    31.58 user
    0.72 sys

So I guess this is the best I could do.