2 ms·
That's why you can `EXPLAIN` your query, and maybe even add indices, to speed things up! Plus in the last few years SQLite has gotten a lot more powerful, and
by lsb 7y ago
That's why you can `EXPLAIN` your query, and maybe even add indices, to speed things up!
Plus in the last few years SQLite has gotten a lot more powerful, and has added lots of JSON support and has improved index usage. I'd avoid working with lots of data as flat ASCII text, because of all the I/O and wasted cycles to read the data and insert it into some data structure and then write it out as flat ASCII text, but it can be super debuggable.