mrbdrm wrote auto refresh to a simple query every 45sec the query table are small in size and the query take a less than a second to complete.
Honestly, building a web application that spans over internet and you have a query executing every 45 sec times # of LoggedInUsers, is a poor design. I wouldn't even run this type of app on a intranet network or a client/server. The probability of so many query executions overlapping each other for 200 users, is so high and that's why you get so many connections which drains the whole system.
You need to approach your system differently, where the user initiate that query when she only needs it. I have seen apps that one rule triggers other rules that trigger others. And the first one gets constantly triggered per update. That is where Aware gets abused.
