From: Anupam Karmarkar
Date: June 7 2011 12:55pm
Subject: Fastest Select
List-Archive: http://lists.mysql.com/mysql/225197
Message-Id: <646575.45494.qm@web94715.mail.in2.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-18943544-1307451311=:45494"

--0-18943544-1307451311=:45494
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

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 recor=
d exists in table or not and=A0 requirement is response time should be less=
 than 10 million second for nearly 1000 concurrent requests, what is best w=
ay to tune this table, table is kind of very static and we load data weekly=
 once only,=20
Which engine is good MyISAM or InnoDB with index ?
Will any partitioning on this table help?

--Anupam

--0-18943544-1307451311=:45494--