3 ms·
How long does it take when using the native CSV import features? https://www.sqlite.org/csv.html https://www.sqlite.org/csv.html
by orf 5y ago
How long does it take when using the native CSV import features?
https://www.sqlite.org/csv.html https://www.sqlite.org/csv.html
- motoboi 5y agoIt’s fast. But then we need a “1 billion CSV lines” article.
- orf 5y agoWhich I expect is significantly faster to generate. You could probably combine it with a pipe to avoid all disk IO.
- tanin 5y agoI built https://superintendent.app https://superintendent.app and experimented a lot with this feature. I can import 1GB CSV file in 10 seconds on my MacBook. This queries from a virtual table and puts it in actual table
- freeqaz 5y agoThis 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. :)