Menu
Community /Pin to ProfileBookmark
@NogDogSep 08.2008 — #For the script's efficiency, it would be better to just have one connect -> select -> close sequence. If the script is very large and complex and takes some time (in computer terms) between database operations, it might be better from the overall system/site viewpoint to have separate connections for each portion of the script that needs to access the database so as to avoid possibly having concurrent scripts have to wait for a connection. But as this would likely only be an issue for very "busy" scripts on a very busy web site, I'd say that the vast majority of the time a single connection would be my preference.
mysql_close()
If I have some classes that represent objects in a database, is it better to have a call to mysql_connect() and mysql_select_db() and then mysql_close() in only the functions that require access to the database, or is it better to just have one call to mysql_connect() and mysql_select_db() in a configuration script and require_once() that script at the top of every class, keeping the connection open throughout every script until the page is finished?
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogSep 08.2008 — #