[thelist] PHP/MSQL question millions or thousands

Fred D Yocum fdy at mcc.org
Wed Feb 6 08:01:27 CST 2008

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

Fred D

More information about the thelist mailing list