RE: Large selects handled inefficiently? - Mailing list pgsql-general

From Andrew Snow
Subject RE: Large selects handled inefficiently?
Date
Msg-id NHEALMDKDACEIPBNOOOCCEGBCLAA.als@fl.net.au
Whole thread Raw
In response to Large selects handled inefficiently?  (Jules Bean <jules@jellybean.co.uk>)
Responses Re: Large selects handled inefficiently?  (Jules Bean <jules@jellybean.co.uk>)
List pgsql-general
> I believe I can work around this problem using cursors (although I
> don't know how well DBD::Pg copes with cursors).  However, that
> doesn't seem right -- cursors should be needed to fetch a large query
> without having it all in memory at once...

Actually, I think thats why cursors were invented in the first place ;-)  A
cursor is what you are using if you're not fetching all the results of a
query.


- Andrew








pgsql-general by date:

Previous
From: "Adam Lang"
Date:
Subject: Re: foreign keys - script
Next
From: Travis Bauer
Date:
Subject: Cursors and JDBC