Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 86A6F632C49 for ; Tue, 15 Jun 2010 09:25:43 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 08856-08 for ; Tue, 15 Jun 2010 12:25:36 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp-vbr5.xs4all.nl (smtp-vbr5.xs4all.nl [194.109.24.25]) by mail.postgresql.org (Postfix) with ESMTP id EF611632AEE for ; Tue, 15 Jun 2010 09:25:35 -0300 (ADT) Received: from roundcube.xs4all.nl (roundcube6.xs4all.nl [194.109.20.204]) by smtp-vbr5.xs4all.nl (8.13.8/8.13.8) with ESMTP id o5FCP3eb003693; Tue, 15 Jun 2010 14:25:03 +0200 (CEST) (envelope-from vinny@xs4all.nl) Received: from 82-170-94-236.vodafonevast.nl ([82.170.94.236]) by roundcube.xs4all.nl with HTTP (HTTP/1.1 POST); Tue, 15 Jun 2010 14:25:02 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Date: Tue, 15 Jun 2010 14:25:02 +0200 From: vinny To: AI Rumman Cc: Andrew McMillan , Subject: Re: large resultset In-Reply-To: References: <8f468dc246fb6075f2a1f46b09f71a6d@xs4all.nl> <1276598244.3820.16204.camel@happy.home.mcmillan.net.nz> Message-ID: X-Sender: vinny@xs4all.nl (7sL8sXaoegI3fODYvNYzUA==) User-Agent: XS4ALL Webmail X-Virus-Scanned: by XS4ALL Virus Scanner X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.011 tagged_above=-10 required=5 tests=BAYES_40=-0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201006/11 X-Sequence-Number: 4150 On Tue, 15 Jun 2010 18:03:24 +0600, AI Rumman wrote: > Thanks a lot. > Actualy I am new with Postgresql. > I am using POstgresql 8.1. > The application is for giving the administrator all their email > activities. Thats why it is 2 million of records. It is an CRM > application. > But do you want to display all 2 Million rows on screen? Because that's not going to work. If you just want to offer the data as a download you're ok if you do it in SQL and do not send all rows seperately.