benefit of calling mysql_close()

Question

Possible Duplicates:
using mysql_close()
close mysql connection important?

What are the benefits of closing the connection using mysql_close() as the last line of your script compared to letting php close it for you?

Also duplicate of: http://stackoverflow.com/questions/2244092/when-should-i-close-the-db-connection — thomasrutter, Aug 11 '10 at 05:25
Another: http://stackoverflow.com/questions/3305556/php-mysql-database-connection — thomasrutter, Aug 11 '10 at 05:25
Another (this one has some good answers): http://stackoverflow.com/questions/880885/close-mysql-connection-important — thomasrutter, Aug 11 '10 at 05:26
plenty of good answers to choose from in the above, hope they help :) — thomasrutter, Aug 11 '10 at 05:29

score 2 · Accepted Answer · answered Aug 11 '10 at 05:20

2

None if you have it as the last line of the script.

You can improve performance by closing as soon as you are done so the handle is available for other processes to use.

This implies you are doing some other stuff after you are done with the db.

answered Aug 11 '10 at 05:20

Byron Whitlock

52,691
28
123
168

score 0 · Answer 2 · answered Aug 11 '10 at 05:31

None, using it before the end of script can free up one mysql connection and probably little Ram on php server.

But reopening connections to mysql is slow, so imho you'd better let php call it at end of execution, or use persistent connections.

Generally php scripts are run for milliseconds, even with good traffic hits, getting a high number (I mean 100+ at least) connections on mysql is rare. And again if this happens, use persistent connections.

benefit of calling mysql_close()

2 Answers2