hey im building an air app that uses asSQL and MySQL which is running on a shared hosting enviroment.
im having a problem where if i jsut let my app sit for a few minutes it throws an error saying "Error: Server terminated connection!" and it stops running.
ive worked with a few database technologies and have never come across this problem befor. i contactd my hosting company and they told me that mysql only allows a certaint amount of connections so it will push you out if not in use. im wondering if this is true for all my MySQL or just for this hosting enviroment ( i plan on switching over to a MySQL database on Amazon EC2 ). i need thousands of people to be able to connect and not have the app crash when the connection times out. anyone have any insight on how i might accomplish this?