Re: EDS database speed questions
- Posted by bryanso Sep 02, 2008
- 1092 views
With 2.2 million, EDS needs to do a maximum of 45 disk seeks to
find any record. This is on par with B-Tree accessing.
find any record. This is on par with B-Tree accessing.
Derek, this cannot be right. Perhaps on par with Binary Tree accessing, yes. But B-Tree / B+ Tree certainly has much, much less disk accesses because multiple keys are kept per block. I'm guessing mysql probably can get to a record in 5 disk accesses.
The insertion of new records is going to give you performance issue if you don't go with an external RDBMS like mysql. But may be your data set is static.
Bryan