Currently, I am developing a notification system using Play Framework 2.3 (Java) in combination with MySQL.
The system is designed to retrieve notifications from a "notifications" table stored in MySQL database.
I initially attempted to use AJAX polling where periodic asynchronous requests are made every 30 seconds to check for new notifications in the table. However, due to performance issues, particularly under heavy user loads, I am seeking alternative solutions.
Could anyone suggest the most effective approach to implement such a system? Are there any recommended Java libraries that would simplify this process?
Thank you for your help and insights.