Hi Anupam,
how do you load data? is it naturally ordered in any way?
Claudio
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
> only,
> Which engine is good MyISAM or InnoDB with index ?
> Will any partitioning on this table help?
>
> --Anupam
>
--
Claudio
