3 ms·
Not really. If your table does not fit into memory, there is a good chance that a disk seek is required. Now all bets are off.
by agnivade 10y ago
Not really. If your table does not fit into memory, there is a good chance that a disk seek is required. Now all bets are off.
- invaliduser 10y agoBy table you mean index, right ? What matters most is the size of the index, and most index data structures (see btrees) work so that very few disk seeks are needed, even if the index is large.
- orf 10y agoPerhaps if you're using a really slow spinning disk and have no indexes, or the results are distributed evenly across the entire dataset (i.e lots of random, non sequential access). It's just 300ms is really slow, even with a largeish dataset that doesn't fit into memory. Perhaps you hit a corner case in some way that destroyed performance in sqlite, but I'd be surprised if those results were representative.