RE: Large selects handled inefficiently?

Поиск
Список
Период
Сортировка
От Andrew Snow
Тема RE: Large selects handled inefficiently?
Дата
Msg-id NHEALMDKDACEIPBNOOOCCEGBCLAA.als@fl.net.au
обсуждение исходный текст
Ответ на Large selects handled inefficiently?  (Jules Bean <jules@jellybean.co.uk>)
Ответы Re: Large selects handled inefficiently?  (Jules Bean <jules@jellybean.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: "Adam Lang"
Дата:
Сообщение: Re: foreign keys - script
Следующее
От: Travis Bauer
Дата:
Сообщение: Cursors and JDBC