OK, time to come clean. Right now my app is doing something really cheesy. The first step is alway admitting that you have a problem, right?
So here's the deal. One of the features of my app is that, based on some user settings, it is supposed to send out "reminder" emails at certain times of the day. Each user has their own time settings for these reminders. Right now I have a background task that, once every 15 mins, looks at every gosh darn user and decides whether or not to send them a reminder. Once every 15 mins I hit every single user row in the database. brrrrrrr. Yeah, I know, gives me the willies too. So is there some sort of a "best practice" established for how to do some caching/intelligent-scheduling to overcome this horrendous mis-use of the database? Is there some sort of a plugin that would allow me to sort the database by that time-of-day column and intelligently find just those within a certain range of times? I'm very nearly an SQL virgin, so if this is painfully simple and I'm just a moron, be gentle. thanks, jp -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
