[thelist] PHP/MSQL question millions or thousands

[Fred D Yocum]

I am planning a recipe MSQL database (for a Web site) and would like to be 
able to search/extrapolate via single ingredients (list of all recipes 
with carrots).

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)?

TIA
Fred D