- Original Message -
> From: "Anupam Karmarkar"
>
> select * from XYZ where key = 123;
>
> Now if i have to load data feed of 10 million once in week i need to
> consider loading time also
Yes, On InnoDB you can't disable the primary key, as the data is
index-organized. The reason why t
, Johan De Meersman wrote:
From: Johan De Meersman
Subject: Re: Fastest Select
To: "Claudio Nanni"
Cc: mysql@lists.mysql.com, "Anupam Karmarkar"
Date: Wednesday, 8 June, 2011, 10:53 AM
- Original Message -
> From: "Claudio Nanni"
>
> how do yo
- Original Message -
> From: "Claudio Nanni"
>
> how do you load data? is it naturally ordered in any way?
Also, what's the record structure, and what are the criteria you use to check
if a record exists?
If you only need to know wether a given record exists, your best bet is
probab
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 no
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, wha