MySQL Forums
Forum List  »  Partitioning

Partitioning or indexing for millions of records
Posted by: Aamir Sohail
Date: November 26, 2013 05:44AM

Hii all,

I have a table containing 20+ millions(will go to 60+ within month) of records. Now I have to fetch records very fast.

I am using MyISAM engine and i don't want to create problem during insertion(heard indexing can hurt insertion) of records. So please tell me which is better indexing or partitioning.

What other factors(cache or buffering) i should use. Please let me know with example if possible.

Thank you.

Edited 2 time(s). Last edit at 11/27/2013 12:58AM by Aamir Sohail.

Options: ReplyQuote

Written By
Partitioning or indexing for millions of records
November 26, 2013 05:44AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.