pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Raymond O'Donnell <rod@iol.ie>
To: AI Rumman <rummandba@gmail.com>
Cc: Thom Brown <thombrown@gmail.com>
Cc: vinny <vinny@xs4all.nl>
Cc: pgsql-php@postgresql.org
Subject: Re: large resultset
Date: Tue, 15 Jun 2010 11:15:31 +0100
Message-ID: <4C1752C3.9080405@iol.ie> (raw)
In-Reply-To: <AANLkTinfQIZXAcJE6GBD6P1AsOVnli9UuZDMl7BvbeHl@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>

On 15/06/2010 11:01, AI Rumman wrote:
> No. I need to send 2 million records. I want to know what is the best
> possible way to send these records?
> HOw should I write the plpgsql procedure to send record ony by one to
> improve the response time to the users?

Are you really going to display all 2 million at once? Surely you'd be
better off displaying smaller pages at a time.

In any case, you haven't been clear about what you are trying to do - if
you explain in more detail, we'll be better able to help.

Ray.

-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie



view thread (14+ messages)  latest in thread

Message-ID: <4C1752C3.9080405@iol.ie>
Permalink:  ../4C1752C3.9080405@iol.ie/
Also on:    postgresql.org/message-id/4C1752C3.9080405@iol.ie

 · 

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: rod@iol.ie, rummandba@gmail.com, thombrown@gmail.com, vinny@xs4all.nl
  Subject: Re: large resultset
  In-Reply-To: <4C1752C3.9080405@iol.ie>
  References: <AANLkTinXSz6PsoTyPhryAHsN3V-M0v-m3sTCLTJSJttO@mail.gmail.com> <AANLkTimP7qSASY3dRA09p6e35CzRLo8pOyZ6J5_5Bisx@mail.gmail.com> <8f468dc246fb6075f2a1f46b09f71a6d@xs4all.nl> <AANLkTimJPh6X78KS0rflYhLcldMtrIq8S4HfMVMKUJfS@mail.gmail.com> <AANLkTinfQIZXAcJE6GBD6P1AsOVnli9UuZDMl7BvbeHl@mail.gmail.com> <4C1752C3.9080405@iol.ie>

* 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