Hey all,

let's say you have a website that needs to be multilingual - so you create a table like this:

ws_text
ws_text_id (int)
ws_language_id (int)
ws_text_code (string)
ws_text_value (string)
ws_last_modified (datetime)

and you have a similar mapped hibernate object.

The thing is this data RARELY changes, so there is no need to request it from the database every time a user hits the website. However it does change SOMETIMES (say once every couple months). Is there a good way to map say the last_modified column in hibernate so it caches the request until the last_modified date changes? Or would you use a cron job to refresh the text once every 48 hours? Or, what do you think is the best way to handle data that rarely changes?

Any help would be appreciated