Page 1 of 1

drop down list... scalability & performance?

Posted: Fri Apr 08, 2005 9:14 pm
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

Posted: Sat Apr 09, 2005 11:56 am
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.