Hi Anupam, how do you load data? is it naturally ordered in any way?
Claudio 2011/6/7 Anupam Karmarkar <sb_akarmar...@yahoo.com> > 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