pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Martin Marques <martin@bugs.unl.edu.ar>
To: Joe Nilson Zegarra Galvez <nzegarra@kolareal.net>
Cc: LISTA PGSQL-PHP <pgsql-php@postgresql.org>
Subject: Re: Postgres connection
Date: Wed, 20 Aug 2003 12:04:45 -0300
Message-ID: <200308201204.46013.martin@bugs.unl.edu.ar> (raw)
In-Reply-To: <1061298784.2525.2.camel@dune.dcielo.com>
References: <1061298784.2525.2.camel@dune.dcielo.com>

El Mar 19 Ago 2003 10:13, escribió:
> Hi all, i have a question, i have a php file with all my class to
> connect into a postgresql db and i'm using the pg_connect in this form:
>
> pg_connect("192.168.1.X","","","",$dbase);

Change this to what the manual says:

http://www.php.net/manual/en/function.pg-connect.php

See that it passes only one argument.

> but when i have 8 or 10 users inserting data, the db response is very
> slow, is problem in the pg_connect?, all ppl use the same file_class.php
> to connect to the db.
>
> The Server is a Compaq Proliant with two Xeon 2.20Ghz Processors, 1Gb
> Memory, 20Gb SCSI HD, 1Gb Ethernet and Redhat Linux 8.0 with apache
> 2.0.47,
> php 4.2.2 and PostgreSQL 7.2.2
>
> How can i do better the response of the server?

Depends on what your postgresql.conf file says.

Check these links:

http://www.varlena.com/GeneralBits/Tidbits/perf.html

http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html

Saludos... :-)

-- 
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------




view thread (3+ messages)

Message-ID: <200308201204.46013.martin@bugs.unl.edu.ar>
Permalink:  ../200308201204.46013.martin@bugs.unl.edu.ar/
Also on:    postgresql.org/message-id/200308201204.46013.martin@bugs.unl.edu.ar

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: martin@bugs.unl.edu.ar, nzegarra@kolareal.net
  Subject: Re: Postgres connection
  In-Reply-To: <200308201204.46013.martin@bugs.unl.edu.ar>
  References: <1061298784.2525.2.camel@dune.dcielo.com> <200308201204.46013.martin@bugs.unl.edu.ar>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox