Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0B622475B8C for ; Tue, 3 Sep 2002 23:17:31 -0400 (EDT) Received: from webphilippines.com.ph (unknown [61.9.41.33]) by postgresql.org (Postfix) with SMTP id 84B0D475B8D for ; Tue, 3 Sep 2002 23:17:25 -0400 (EDT) Received: from [202.8.229.178] (HELO webphilippines.com) by webphilippines.com.ph (Stalker SMTP Server 1.7) with ESMTP id S.0000398660 for ; Wed, 04 Sep 2002 11:12:14 +0800 Message-ID: <3D757D27.93026D55@webphilippines.com> Date: Wed, 04 Sep 2002 11:25:28 +0800 From: Ric =?iso-8859-1?Q?Ma=F1alac?= X-Mailer: Mozilla 4.73 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-php@postgresql.org Subject: fastest way to retrieve data X-Priority: 1 (Highest) Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/9 X-Sequence-Number: 1464 hi, is there a faster way to retrieve data from postgresql using php aside from the conventional way of looping through the number of records returned by pg_num_rows then executing pg_fetch_row on each iteration? isn't it possible to get the entire result set returned by pg_exec and save that to a multi-dimensional array? this way the program can disconnect from the db and just get the data from the multi-dimensional array. this would also shorten the number of requests to postgresql. would appreaciate any suggestions. thanks! regards, -- Ric Maņalac http://www.webphilippines.com http://www.trabaho.com http://www.kasal.com Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you.