Hi Srinivas,

With Php/Postgres/Apache what issues i see is the configuration directives that u have given while compiling php with postgres and apache, here are some configuration parameters you can see:

Postgres Configuration Directives:

pgsql.allow_persistent boolean Whether to allow persistent Postgres connections.

pgsql.max_persistent integer The maximum number of persistent Postgres connections per process.

pgsql.max_links integer The maximum number of Postgres connections per process, including persistent connections.

So your php{3/4}.ini file should have these types of values assigned for these directives: [PostgresSQL] ; Allow or prevent persistent links. pgsql.allow_persistent = On

; Maximum number of persistent links. -1 means no limit. pgsql.max_persistent = -1

; Maximum number of links (persistent+non persistent). -1 means no limit. pgsql.max_links = -1

If these values are fixed then you might get problems what you are talking about. These values can also be read from phpinfo() in a php script file, so u necessarily need not open this file.

Srinivas Wrote:

Hi ,

We are using apache php and portgresql for one of our web based accounting package . Initially we were using pconnect then we stated getting too many connection errors the moment more than five users loged in. So we switched to connect , but problme is the whole system runs very slow . Infact i would like to get some optimisation techniques for all this kind of setup .

Regards

For Optimal Solution Providers

T. Srinivas

Regards

Paresh Parihar

_________________________________________________________________ Cricket World Cup 2003- News, Views and Match Reports. http://server1.msn.co.in/msnspecials/worldcup03/