how do you load data? is it naturally ordered in any way?
2011/6/7 Anupam Karmarkar <sb_akarmarkar@stripped>
> Hi All,
> We have very big table with few column contains nearly 10 million records,
> We need to tune this table for simple select statement where we check record
> exists in table or not and requirement is response time should be less than
> 10 million second for nearly 1000 concurrent requests, what is best way to
> tune this table, table is kind of very static and we load data weekly once
> Which engine is good MyISAM or InnoDB with index ?
> Will any partitioning on this table help?