RE: Large selects handled inefficiently?
Andrew Snow <als@fl.net.au>
From: "Andrew Snow" <als@fl.net.au>
To: "Pgsql-General@Postgresql. Org" <pgsql-general@postgresql.org>
Date: 2000-08-30T14:22:36Z
Lists: 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