X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id AF343D1BB97 for ; Wed, 20 Aug 2003 12:07:51 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 85027-05 for ; Wed, 20 Aug 2003 12:07:40 -0300 (ADT) Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by svr1.postgresql.org (Postfix) with ESMTP id 34580D1BA23 for ; Wed, 20 Aug 2003 12:07:39 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id 474A91211B; Wed, 20 Aug 2003 12:04:47 -0300 (ART) From: Martin Marques To: Joe Nilson Zegarra Galvez Subject: Re: Postgres connection Date: Wed, 20 Aug 2003 12:04:45 -0300 User-Agent: KMail/1.5.2 References: <1061298784.2525.2.camel@dune.dcielo.com> In-Reply-To: <1061298784.2525.2.camel@dune.dcielo.com> Cc: LISTA PGSQL-PHP MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200308201204.46013.martin@bugs.unl.edu.ar> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/89 X-Sequence-Number: 2266 El Mar 19 Ago 2003 10:13, escribi=F3: > 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... :-) --=20 Porqu=E9 usar una base de datos relacional cualquiera, si pod=E9s usar PostgreSQL? ----------------------------------------------------------------- Mart=EDn Marqu=E9s | mmarques@unl.edu.ar Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------