Querying the database frequently. Any patterns?

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

Date: Tue, 18 Nov 2003 23:10:02 +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

  • Re: How to have rule send notification to main inbox when msg appears in generic mailbox?
    ... Author of Configuring Microsoft Outlook 2003 ... perhaps by sending me a notification to my main inbox. ... but when I test this by manually sending a message to the ... I don't get a notification message in my main inbox. ...
    (microsoft.public.outlook)
  • Querying the database
    ... I have a calendar application(like Microsoft Outlook) writtn in ... we can set SMS/EMAIL notification. ...
    (comp.lang.java.databases)
  • Querying the database frequently
    ... I have a calendar application(like Microsoft Outlook) writtn in ... we can set SMS/EMAIL notification. ...
    (comp.lang.java)
  • Re: Querying the database frequently. Any patterns?
    ... > I have a calendar applicationwrittn in ... > Java.Whenever an event is created, we can set SMS/EMAIL notification. ... Never use a database as an interface between two sub-systems - this is a well know ...
    (comp.object)
  • Re: Querying the database
    ... Ravi Shankar wrote: ... > I have a calendar applicationwrittn in ... > Java.Whenever an event is created, we can set SMS/EMAIL notification. ...
    (comp.lang.java.databases)