I have a Python bot inserting messages on MySQL, and i need to create a web page to show the messages, this page will be used by about 10 thousand users, i can’t use requests.
I need to create script php to listener mysql inserts, every new insert, show in PHP Page(without reload page or something else). I created using Ajax, sending requests every 2 seconds, but, my mysql host have limits per hour, i need to create other solution, like a websocket/mysql listener. Without requests.
What is the best solution for me to create?