Hi everyone,
I just had a quick question regarding connections to a mySQL database, but first let me just tell you a little bit about my database...
- Everytime a user registers, their information is validated and entered in my database, which leads me to my first question:
Q: Is it necessary to connect EVERY time a user registers? Or can I just connect once and send all queries through this connection?
- If the above is possible:
Q: How long will this connection last? Is there a timeout after a few hundred seconds or will this connection remain open until I close it? If it will remain open until I close it, would it be a good idea for me to run a cronjob daily which closes and then reopens the connection at...say midnight?
- If the first question is not possible:
Q: How many connections are supported by mySQL? What happens when this limit is reached?
Thats it for now
. Thanks very much for your help everyone!
- Matt
I just had a quick question regarding connections to a mySQL database, but first let me just tell you a little bit about my database...
- Everytime a user registers, their information is validated and entered in my database, which leads me to my first question:
Q: Is it necessary to connect EVERY time a user registers? Or can I just connect once and send all queries through this connection?
- If the above is possible:
Q: How long will this connection last? Is there a timeout after a few hundred seconds or will this connection remain open until I close it? If it will remain open until I close it, would it be a good idea for me to run a cronjob daily which closes and then reopens the connection at...say midnight?
- If the first question is not possible:
Q: How many connections are supported by mySQL? What happens when this limit is reached?
Thats it for now
. Thanks very much for your help everyone!- Matt