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
