Win a copy of Head First Agile this week in the Agile forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Connecting to static information in my JSP application.  RSS feed

 
Susan Smith
Ranch Hand
Posts: 224
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have a 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
Author and ninkuma
Marshal
Posts: 66208
151
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Grab the information in a context listener when the app starts up, and store it in the application context for easy access.
 
Murthy Tanniru
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can use caching which allows you to refresh cache once a day for any reason if the data changes
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!