Re: EDS database speed questions

new topic     » goto parent     » topic index » view thread      » older message » newer message

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.

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

new topic     » goto parent     » topic index » view thread      » older message » newer message

Search



Quick Links

User menu

Not signed in.

Misc Menu