I have a raspberry pi 3 webserver.
When user gets into my app. App is sending a post request to my server every second to check if there are any messages for user.
The query is simple: SELECT message FROM messages WHERE id=id
I'm using innodb and node js for handling post requests.