3 ms·
When working with large csv files, you're better off importing the file into a sqlite database if you want to perform more than one query. Knowing the import i
by xn 5y ago
When working with large csv files, you're better off importing the file into a sqlite database if you want to perform more than one query.
Knowing the import is happening behind the scenes is useful when you hit performance problems with the tool.
- thesnide 5y agoUsing a local cache might indeed improve for following queries. But I managed to be able to "stream" results. When it didn't involve any GROUP BY, of course. I guess that would spawn a nice side project, to rewrite it in a language to learn it ;-)