There is a table in Mysql that suffers many insertions.
The application needs to show these changes to the client.
Currently the existing application queries the table every 10 seconds and displays the contents of the table.
Is there any way that the bank itself informs when there are changes in the table? Or is there a way to improve this kind of scenario?
The problem is the infinite loop that jquery gets, sending every 10 seconds a post to capture the information in the database.