Re: Querying the database

From: Neil Green (neil_green_at_no.spam.hotmail.com)
Date: 11/19/03

  • Next message: Otto Perdeck: "Re: Why is com.microsoft.jdbc.sqlserver.SQLServerDriver so slow?"
    Date: Tue, 18 Nov 2003 23:45:53 +0000
    
    

    Ravi Shankar wrote:
    > 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
    >
    >
    >

    I suggest you see the answer I posted in c.l.j.beans earlier. If you
    must cross post, please do it porperly!


  • Next message: Otto Perdeck: "Re: Why is com.microsoft.jdbc.sqlserver.SQLServerDriver so slow?"

    Relevant Pages

    • Re: Querying the database frequently. Any patterns?
      ... Ravi Shankar wrote: ... > Java.Whenever an event is created, we can set SMS/EMAIL notification. ... wouldn't worry until the query interval is in the order of seconds. ... you will want to mark the message as "sent" once it ...
      (comp.object)
    • 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)
    • Querying the database frequently
      ... I have a calendar application(like Microsoft Outlook) writtn in ... we can set SMS/EMAIL notification. ...
      (comp.lang.java)
    • 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. Any patterns?
      ... I have a calendar application(like Microsoft Outlook) writtn in ... we can set SMS/EMAIL notification. ...
      (comp.object)