Re: large resultset - Mailing list pgsql-php

From Raymond O'Donnell
Subject Re: large resultset
Date
Msg-id 4C1752C3.9080405@iol.ie
Whole thread Raw
In response to Re: large resultset  (AI Rumman <rummandba@gmail.com>)
List pgsql-php
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

pgsql-php by date:

Previous
From: Andrew McMillan
Date:
Subject: Re: large resultset
Next
From: Jasen Betts
Date:
Subject: Re: large resultset