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 modest PC 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 also --Anupam --- On Wed, 8/6/11, Johan De Meersman <vegiv...@tuxera.be> wrote: From: Johan De Meersman <vegiv...@tuxera.be> Subject: Re: Fastest Select To: "Claudio Nanni" <claudio.na...@gmail.com> Cc: mysql@lists.mysql.com, "Anupam Karmarkar" <sb_akarmar...@yahoo.com> Date: Wednesday, 8 June, 2011, 10:53 AM ----- Original Message ----- > From: "Claudio Nanni" <claudio.na...@gmail.com> > > 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 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=sb_akarmar...@yahoo.com
