[thelist] PHP/MSQL question millions or thousands

Matt Warden mwarden at gmail.com
Wed Feb 6 08:34:19 CST 2008

On 2/6/08, mac jordan <mac.jordan at gmail.com> wrote:
> On Feb 6, 2008 2:01 PM, Fred D Yocum <fdy at mcc.org> wrote:
> > 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).
> >
> Been there, done that - see www.nibblous.com.
> I went with a full text search run every night (using Perlfect), coupled
> with a tag cloud.

>From a usability perspective, this may be a better idea. Otherwise,
you're going to force the user to search for each ingredient they want
in the recipe they are creating (because you need the ingredient ID to
insert the recipe).

If nothing else, at least use the autocomplete pattern!

Matt Warden
Cincinnati, OH, USA

This email proudly and graciously contributes to entropy.

More information about the thelist mailing list