X-Original-To: pgsql-performance@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id ADC6A92627B for ; Sun, 1 Jun 2003 21:49:00 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 34215-05 for ; Sun, 1 Jun 2003 21:48:50 -0400 (EDT) Received: from simmts1-srv.bellnexxia.net (simmts1.bellnexxia.net [206.47.199.10]) by developer.postgresql.org (Postfix) with ESMTP id BC721926279 for ; Sun, 1 Jun 2003 21:48:49 -0400 (EDT) Received: from [192.168.1.200] ([64.231.215.231]) by simmts1-srv.bellnexxia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20030602014846.HTYN10472.simmts1-srv.bellnexxia.net@[192.168.1.200]>; Sun, 1 Jun 2003 21:48:46 -0400 Subject: Re: Select Query Performance From: Rod Taylor To: Ricky Prasla Cc: Postgresql Performance In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-+J0N3oXGLc3BnDIgO0sv" Organization: Message-Id: <1054518510.77081.4.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4 Date: 01 Jun 2003 21:48:31 -0400 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200306/7 X-Sequence-Number: 2091 --=-+J0N3oXGLc3BnDIgO0sv Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > 2)Also, I execute this query over the web. If there are mltiple select=20 > queries then I have to execute one get its reultset and then send the oth= er=20 > one. Is there a faster way to execute multiple select queries over the we= b? Going with the assumption the result-set is not used to generate further queries, you might look into the use of Asynchronous connections. It'll enable you to easily establish several connections to the database for parallel work to be done. http://www.postgresql.org/docs/view.php?version=3D7.3&idoc=3D1&file=3Dlibpq= -connect.html Even PHP will let you use the Asynchronous query mechanism within PostgreSQL. --=20 Rod Taylor PGP Key: http://www.rbt.ca/rbtpub.asc --=-+J0N3oXGLc3BnDIgO0sv Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQA+2qzu6DETLow6vwwRAlf7AJ4jNOk6lRqk6CtQmUGVfMOzJaH2JgCffVAX O1PRZeqHfb42LPdgEPmYo0I= =HpHp -----END PGP SIGNATURE----- --=-+J0N3oXGLc3BnDIgO0sv--