mySQL connection question...

[Anon]

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

[glowball]

See http://www.phpbuilder.com/forum/read.php3?num=2&id=123891&loc=0&thread=123891.

[[deleted]]

1 & 2 read the PHP manual about pconnect() and then proceed to forget about it because it's only good for large servers with hundreds of connections/sec.

You MUST use the mysql_connect() for EVERY script that needs a database connection.

3 MySQL has a limit of around 1000 unless I am much mistaken.
What happens when the limit is reached? Then the server will refuse to open more connections ofcourse.

[Anon]

your all php files which will be connect to database must have connection codes on it!
you must connect in every your file. in every your php files execution end you are disconnecting from database automatically! but you can use (send) many queries in one connection.