[PHP] reuse database connections

2002-09-18 Thread Support @ Fourthrealm.com
Another question about efficiency / using server resources: In another language I use, I can re-use an ODBC connection to make further queries/update/etc to the database to save the overhead of closing and reopening the connection to the db over and over. It works sometime like this (in the

Re: [PHP] reuse database connections

2002-09-18 Thread Kumar Lakshminarayanan
You can use persistent connections from php to mysql server using mysql_pconnect(host,user,passwd) then go on to use the returned link. this will open a new connection only if one is not available. kumar Support @ Fourthrealm.com wrote: Another question about efficiency / using server

Re: [PHP] reuse database connections

2002-09-18 Thread olinux
When you create a connection it is available to the end of the script run. You can run as many queries as you wish in the script and all will use the same connection. If you wish for multiple accesses to use the same connection, I think you will have to use persistent connections. olinux ---