I am loading data using LOAD DATA as source is csv file.
My selection is very simple with like
select * from XYZ where key = 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
I created MyISAM table with key it took nearly 7 min to load data into table,
I created MyISAM table with hash partition it took nearly 1 and 1/2 hour
with InooDB and Partition got descent result for select
Now if i have to load data feed of 10 million once in week i need to consider loading time
--- 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>
> 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
If you only need to know wether a given record exists, your best bet is probably going to
be InnoDB with the lookup fields as primary key - assuming they'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.
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1