List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:June 8 2011 5:23am
Subject:Re: Fastest Select
View as plain text  

----- 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
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
Thread
Fastest SelectAnupam Karmarkar7 Jun
  • Re: Fastest SelectClaudio Nanni7 Jun
    • Re: Fastest SelectJohan De Meersman8 Jun
      • Re: Fastest SelectAnupam Karmarkar8 Jun
        • Re: Fastest SelectJohan De Meersman8 Jun