Fastest Select

[Anupam Karmarkar]

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