I have an R model, which predicts user ratings and writes them to database. The question is - what is an optimal way to update these predictions using new incoming data? Now I have a cron task that updates ratings every night, but we need more frequent updates.
What is the proper solution in this situation?
I'm thinking of running a 'continuous' program that connects to database, grabs new data, updates predictions, sets timeout and repeats. I like this solution more than launching cron task because I want to save time loading 1Gb-workspace into memory. Is it ok, what are the major drawbacks?
I understand this is a very dirty solution, we will definitely follow one of the advice here , but now we need a temporary solution