- 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
