drop down list... scalability & performance?

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
Indirectobject
Forum Newbie
Posts: 1
Joined: Fri Apr 08, 2005 9:13 pm

drop down list... scalability & performance?

Post by Indirectobject »

I am developing an web-based recipe application and am looking at starting with phprecipebook (phprecipebook.sourceforge.net)

However, I am concerned over what seems to be a major scalability issue. The application design for adding ingredients to a recipe is to use drop down list for each ingredient, which is auto-filled from the ingredients table.

Currently, there is only a relatively small number of ingredients in the demo (<200) and the page loads OK. But I am wondering what would happen if there were tens of thousands of ingredients, which is realistic.

Anyone have any insight into this area?

Thanks,

Jeff
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

Why don't you catogorize the ingredients and then have seperate smaller drop downs (which are displayed when the category is picked). You could either do this instantly with JavaScript or by reloading the page with the appropriate info from PHP.
Post Reply