Connecting to static information in my JSP application.

[Susan Smith]

Hi,

I have a

<select>

box in my application that I will populate with information from a table. This table is static (no program updates this table), even when it got updated, it will only be updated once in a while manually by data engineer and this table is also very small (78 rows only).

I was thinking even though this table is very small, I don't want to query it everytime in my web application. Let say I have a 1000 user connecting. Even though the table is small, it is still making a lot of connection to the database.

I'm looking for a graceful way to handle this.

Thanks in advance for the help.
[ June 12, 2008: Message edited by: Susan Smith ]

[Bear Bibeault]

Grab the information in a context listener when the app starts up, and store it in the application context for easy access.

[Murthy Tanniru]

You can use caching which allows you to refresh cache once a day for any reason if the data changes