2 ms·
BTW: when you outgrow it, it will be sudden. It’s performance fails in a very non-linear way. Edit: keep the index in memory
by sroussey 4y ago
BTW: when you outgrow it, it will be sudden. It’s performance fails in a very non-linear way.
Edit: keep the index in memory
- mark_l_watson 4y agoI thought the universal practice for getting good performance for relational databases, RDF, other graph, etc. data stores is to be able to hold indices in memory.
- sroussey 4y agoYes, but paged b-trees are more graceful when they can’t fit in memory—which was the default when I cut my teeth on databases. It’s also a reason why MyIsam separated data and index files. InnoDb is a clustered index, so all the data is packed next to the primary key.