Do dynamic menus need optimization?

[uodeltasig]

I'm creating dynamic drop down menu's from a MySQL database just fine but I'm wondering if I should index the content to a file instead of always querying MySQL.

The site I'm working on is a directory, with several categories and sub-categories that are used to limit the results. Currently I am populating Javascript arrays, and when you select a certain category it populates the sub-category using the corresponding array. The categories are periodically updated in the database so hard coding them in Javascript doesn't make sense...

However I wondering if I am putting too much strain on MySQL since it populates the subcategories on the main site, which will get prob. around 100 hits max a day... Would creating a file that re-indexs the categories once a day instead of pulling straight from MySQL be better, or is this just unnecessary work?

Let me know Yay, or Ney with another approach.

THANKS!

[superwormy]

MySQL on any reasonable server should be able to handle thousands and thousands and thousands of simple queries per day with no sweat.

Unless you are having seriously slow page generation times DUE TO SLOW MYSQL QUERIES then I suggest you dont' worry about it.

You can always optimize later if it becomes a problem in the future.