4 ms·
Frankly bizarre article. The author argues that SQLite is inappropriate for storing 16GB of <10KB text files because if you don't index by filename, looking up
by SPBS 4y ago
Frankly bizarre article. The author argues that SQLite is inappropriate for storing 16GB of <10KB text files because if you don't index by filename, looking up a file by its filename is going to be very slow (What he experienced).
He then declares that "The data will now (probably) be transferred to a sharded MySQL database cluster and that will speed up almost anything by large margins.", as if MySQL wouldn't be similarly slow if it had to query 16GB of data without indexes. I don't get his thought process at all, and he writes with such conviction.
- detaro 4y ago... if you agree that the article is bad, why submit it to HN again? (previously https://news.ycombinator.com/item?id=31189341 https://news.ycombinator.com/item?id=31189341)