better solution than timertask with scala in play framework

Question

I need to regularly check the database for updated records. I currently use TimerTask which works fine. However, I've found its efficiency is not good and consumes a lot of server resouces. Is there a solution which can fulfill my requirement but is better?

def checknewmessages() = Action{
    request =>
       TimerTask(5000){
         //code to check database
       }
}

What kind of database are you using ? and what do you want to do when things change - trigger some other event ? — Soumya Simanta, Nov 27 '14 at 17:25
@m-z, no it doesn't. It just adds the record to the channel when new records found. — vaj oja, Nov 28 '14 at 05:22

score 0 · Accepted Answer · edited May 23 '17 at 11:50

I can think of two solutions:

You can use the ReactiveMongo driver for Play which is completely non-blocking and async and capped collection in Mongo DB.

Please see this for an example - https://github.com/sgodbillon/reactivemongo-tailablecursor-demo How to listen for changes to a MongoDB collection?

If you are using a database that doesn't support a push mechanisms you can implement that using an Actor by scheduling messages to itself at regular intervals.

score 0 · Answer 2 · answered Nov 28 '14 at 19:31

If your logic is in your database (stored procedures etc) you could simply create a cron job.

You could also create a command line script that encapsulates the logic and schedule (cron again).

If you have your logic in your web application, you could again create a cron job that simply makes an API call to your app.

better solution than timertask with scala in play framework

2 Answers2