[thelist] PHP/MSQL question millions or thousands

[Matt Warden]

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!
http://developer.yahoo.com/ypatterns/pattern.php?pattern=autocomplete

-- 
Matt Warden
Cincinnati, OH, USA
http://mattwarden.com


This email proudly and graciously contributes to entropy.