vtiger

[walkabout]

In PearDatabase.php the connect() function always uses PConnect ... giving persistent connections. Our database connections list was getting pretty big and that was then causing us some issues in weird places with other programs that use the database. I've just changed the call to "Connect" and that solves it. I think it should be referencing the setting for persistent connections in config though ...

[mikecrowe]

walkabout,

Funny you should mention this. I've been exploring development environments and ran across the same thing. PearDatabase.php completely ignores the settings in config.php and I don't know why.

Richie, any ideas why?

[indigoleopard]

Well, the code was written that way as php did not specify/provide for any persistence mechanism.
Moreover, getting a db connection has its own overhead. So, we decided to use pconnect.

But, I agree, that it too has limitations in the sense that it might hold up all the other connections once the limit is reached for the specific driver.

One can use the variable ADODB_NEVER_PERSIST just before the pconnect mechanism so that it will force using of the normal connect mechanism.

That should suffice.

We will make it variable in the next release wherein default behaviour will be to use persistent connection.

Richie

[mikecrowe]

What confuses me is there are a couple of things in config.php that were put there to control this state.

Please insure we obey the: Code: $dbconfigoption['persistent'] = true;

and that will give the flexibility we need.