• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

Connecting to static information in my JSP application.

 
Ranch Hand
Posts: 224
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
Sheriff
Posts: 67756
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
reply
    Bookmark Topic Watch Topic
  • New Topic