Querying the database frequently

From: Ravi Shankar (sujashankar_at_pacific.net.sg)
Date: 11/18/03 

Date: Tue, 18 Nov 2003 23:09:35 +0800

Hi all,

I have a calendar application( like Microsoft Outlook) writtn in
Java.Whenever an event is created, we can set SMS/EMAIL notification. Hence
when an event is created, I am storing that event info and notification time
into a database.Now the notification can be ranging from 5 minutes to say
one day.Hence I need to query the databse every 5 minutes and fetch the data
and do send the notification directly. I understand that such a querying of
database every 5 minutes is a huge performance penalty. Can any body please
suggest a better way to implement this? Any links please? Any patterns would
be of use? Thanks a lot for the help.

Regards,
Ravi

Relevant Pages