Re: large resultset

Raymond O'Donnell <[email protected]> Tue, 15 Jun 2010 11:15:31 +0100
Newsgroups gmane.comp.db.postgresql.php
Message-ID <[email protected]>
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
[email protected]

-- 
Sent via pgsql-php mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php