By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,737 Members | 1,971 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,737 IT Pros & Developers. It's quick & easy.

Querying the database frequently

P: n/a
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
Jul 17 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ravi. I'm not sure I understand your problem.
If you're capturing the event info (as it is generated) and writing it
to the DB. Why then do you need to query the DB at all. Why not just
synthesize the event info as your receive it, and forward the
notification to your SMS/Email
components to be delivered.
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


Jul 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.