pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: vinny <vinny@xs4all.nl>
To: AI Rumman <rummandba@gmail.com>
Cc: Andrew McMillan <andrew@morphoss.com>
Cc: pgsql-php@postgresql.org
Subject: Re: large resultset
Date: Tue, 15 Jun 2010 14:25:02 +0200
Message-ID: <c5e12c9ffcb8fb5fd2edff5d073fb587@xs4all.nl> (raw)
In-Reply-To: <AANLkTikId6xwBgFhSxQIOpF0rhKps9yCfrUCcdcZeDT4@mail.gmail.com>
References: <AANLkTinXSz6PsoTyPhryAHsN3V-M0v-m3sTCLTJSJttO@mail.gmail.com>
	<AANLkTimP7qSASY3dRA09p6e35CzRLo8pOyZ6J5_5Bisx@mail.gmail.com>
	<8f468dc246fb6075f2a1f46b09f71a6d@xs4all.nl>
	<AANLkTimJPh6X78KS0rflYhLcldMtrIq8S4HfMVMKUJfS@mail.gmail.com>
	<AANLkTinfQIZXAcJE6GBD6P1AsOVnli9UuZDMl7BvbeHl@mail.gmail.com>
	<1276598244.3820.16204.camel@happy.home.mcmillan.net.nz>
	<AANLkTikId6xwBgFhSxQIOpF0rhKps9yCfrUCcdcZeDT4@mail.gmail.com>

On Tue, 15 Jun 2010 18:03:24 +0600, AI Rumman <rummandba@gmail.com> 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.



view thread (14+ messages)  latest in thread

Message-ID: <c5e12c9ffcb8fb5fd2edff5d073fb587@xs4all.nl>
Permalink:  ../c5e12c9ffcb8fb5fd2edff5d073fb587@xs4all.nl/
Also on:    postgresql.org/message-id/c5e12c9ffcb8fb5fd2edff5d073fb587@xs4all.nl

 · 

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: vinny@xs4all.nl, rummandba@gmail.com, andrew@morphoss.com
  Subject: Re: large resultset
  In-Reply-To: <c5e12c9ffcb8fb5fd2edff5d073fb587@xs4all.nl>
  References: <AANLkTinXSz6PsoTyPhryAHsN3V-M0v-m3sTCLTJSJttO@mail.gmail.com> <AANLkTimP7qSASY3dRA09p6e35CzRLo8pOyZ6J5_5Bisx@mail.gmail.com> <8f468dc246fb6075f2a1f46b09f71a6d@xs4all.nl> <AANLkTimJPh6X78KS0rflYhLcldMtrIq8S4HfMVMKUJfS@mail.gmail.com> <AANLkTinfQIZXAcJE6GBD6P1AsOVnli9UuZDMl7BvbeHl@mail.gmail.com> <1276598244.3820.16204.camel@happy.home.mcmillan.net.nz> <AANLkTikId6xwBgFhSxQIOpF0rhKps9yCfrUCcdcZeDT4@mail.gmail.com> <c5e12c9ffcb8fb5fd2edff5d073fb587@xs4all.nl>

* 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