> He used triggers to store the id of the most recent message of every conversation in another table. That is probably the most efficient solution in any databa

> He used triggers to store the id of the most recent message of every conversation in another table. That is probably the most efficient solution in any database. Depends on how often that last message query is run. If it's infrequent, the trigger is just write amplification.