3 ms·
I suspect these opinions would be less likely to get downvoted if you could back them up with data, specifically: - Assuming you do have a test database in adv
by geofft 5y ago
I suspect these opinions would be less likely to get downvoted if you could back them up with data, specifically:
- Assuming you do have a test database in advance that's represented in a file, but for some reason not a SQLite file or other database, how long does it take to load 100M rows in a database of your choice, and how does that compare to the author's results?
- The author does not in fact have a test database in advance, and is generating random data, which I think is what you're saying by "apply your random-number-generating function on a trivial column" - how long would your approach take to generate 100M rows?
- If you generated a database of about the same size in a database of your choice, how do bulk operations on large tables perform in comparison to SQLite? (My understanding is that it's "lite" because it's not client/server, not because its performance is poor.)
I don't think any of these experiments would be terribly hard to run.