2 ms·
To store a billion records in MySQL if you don't needs it's abilities (indexes, joins and updates) is overkill. If you never do updates, and you write your own
by ars 18y ago
To store a billion records in MySQL if you don't needs it's abilities (indexes, joins and updates) is overkill.
If you never do updates, and you write your own index, then a much simpler storage method with far less overhead would be what you need.
- Tichy 18y agoWriting one's own index already seems to be a lot more work than simply setting up MySQL. I get your point, I just have a hard time imagining what could be simpler. Perhaps writing to a sequential file without an index. Although even then I would worry about the capabilities of the file system, which I suppose MySQL would abstract away from me.