3 ms·
I 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 memo
by mark_l_watson 4y ago
I 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.