[thelist] PHP/MSQL question millions or thousands

Martin Burns martin at easyweb.co.uk
Wed Feb 6 08:44:07 CST 2008


On 6 Feb 2008, at 14:04, r937 wrote:

>> For those with experience, which is going to be more efficient --
>> creating a separate entry for each ingredient (millions of little
>> chunks of information) or putting all of the ingredients into one
>> entry and searching within that entry (thousands of chunks of
>> information that need to be search in)?
>
> the former

Not least because the number of discrete ingredients isn't going to be  
that high unless you really are going to be deeply specialist about  
the sourcing of them.

Cheers
Martin

--
 > Spammers: Send me email -> yumyum at easyweb.co.uk to train my filter
 > http://dspam.nuclearelephant.com/








More information about the thelist mailing list