The update greetings job times out without saving to the database

The update greetings job times out with even small databases as calculating these greetings can be an expensive process, specially with the new Smarty tokens. When this job times out, nothing is saved to the database due to the way the update query is built: all results are accumulated in a single query that is only executed at the very end of the process.

A long term fix would be to move the update greetings process from a scheduled job to a separate screen that would be using the Queue Runner paradigm. This would make a lot more sense from an architectural perspective, and could be integrated in the existing Greetings Format administration screens.

A short-term fix would be to flush results to the database every 100 or so contacts, and/or introduce a limit the number of contacts processed through an extra parameters.