From: Claudio Nanni Date: June 7 2011 1:34pm Subject: Re: Fastest Select List-Archive: http://lists.mysql.com/mysql/225198 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=90e6ba6e843854e35f04a51f49b6 --90e6ba6e843854e35f04a51f49b6 Content-Type: text/plain; charset=ISO-8859-1 Hi Anupam, how do you load data? is it naturally ordered in any way? Claudio 2011/6/7 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 > -- Claudio --90e6ba6e843854e35f04a51f49b6--