From: Anupam Karmarkar
Date: June 8 2011 8:04am
Subject: Re: Fastest Select
List-Archive: http://lists.mysql.com/mysql/225208
Message-Id: <402064.15500.qm@web94710.mail.in2.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1039766705-1307520295=:15500"

--0-1039766705-1307520295=:15500
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

I am loading data using LOAD DATA as source is csv file.

My selection is very simple with like

select * from XYZ where key =3D 123;

for 1 million sample record
I created innodb table with key, to load data from csv it took nearly 1 and=
 1/2 hour on modest PC
I created MyISAM table with key it took nearly 7 min to load data into tabl=
e,

I created MyISAM table with hash partition it took nearly 1 and 1/2 hour

with InooDB and Partition=A0 got descent result for select

Now if i have to load data feed of 10 million once in week i need to consid=
er loading time also

--Anupam


--- On Wed, 8/6/11, Johan De Meersman <vegivamp@stripped> wrote:

From: Johan De Meersman <vegivamp@stripped>
Subject: Re: Fastest Select
To: "Claudio Nanni" <claudio.nanni@stripped>
Cc: mysql@stripped, "Anupam Karmarkar" <sb_akarmarkar@stripped>
Date: Wednesday, 8 June, 2011, 10:53 AM



----- Original Message -----
> From: "Claudio Nanni" <claudio.nanni@stripped>
>=20
> 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 che=
ck if a record exists?

If you only need to know wether a given record exists, your best bet is pro=
bably going to be InnoDB with the lookup fields as primary key - assuming t=
hey're unique - as that will give you index lookup without additional data =
block fetch if you request no other fields than those in the index.

Caveats always apply, of course, so extra information may be useful.

--=20
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:=A0 =A0 http://lists.mysql.com/mysql?unsub=3Dsb_akarmarkar@y=
ahoo.com


--0-1039766705-1307520295=:15500--