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/