Re: PHP 4.0 Bug #6033 Updated: Can't open more than one non-persistent connections to the same database

Hello Bug, On 10-Aug-00 05:00:00, you wrote: >ID: 6033 >Updated by: danny >Reported By: mlemos@acm.org >Status: Feedback >Bug Type: Informix related >Assigned To: danny >Comments: >One solution is not to use shared memory connections >(ipcshm) but streams pipes (ipcstr) if you have them, >or tcp/ip (tlitcp or soctcp). It is the recommended way. >Despite what the manual says, ipcshm is not always faster, >it depends on the OS. For some reason I am only able to install and start the Informix server with shared memory. Maybe it's a configuration problem that I am not able to sort. Often Informix error messages are too cryptic to be useful. >Even if you use shared memory connections you can >access as many different databases as you like with >the database:table syntax using one single connection. >You can even have transactions involving different databases >this way. It is certainly more efficient. That is not viable for me because I am developing a Informix driver for Metabase PHP database abstraction package and what you suggest would require me parse and change user queries. Anyway, that is not the worst problem. The worst problem is having to connect to the same server as a different user. I need that when the Metabase manager class installs a new database. First it needs to create the database as DBA user and then it needs to install the schema objects as normal user. What I suggest is that you either effectively close Informix non-persistent connections ifx_Close which is the most expected behaviour and eventually add a new option to php.ini to let users deliberately ask to not close such connections before the end of the script if they really want to. Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org -- E-mail: mlemos@acm.org URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --