Re: DBI/DBD::Pg mem. use goes exponential

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: DBI/DBD::Pg mem. use goes exponential
Дата
Msg-id 455232D3-993A-4BB2-9C2B-90AE59A848F2@khera.org
обсуждение исходный текст
Ответ на Re: DBI/DBD::Pg mem. use goes exponential  (Keary Suska <hierophant@pcisys.net>)
Список pgsql-general
On Sep 29, 2005, at 1:23 PM, Keary Suska wrote:

> You should always finish() every "select" statement handle, or both
> DBI and
> libpq will leak:
>
>     $sth->finish;
>
> after the closing bracket of the while() loop.
>
>

No, you don't need to call finish() if you fall off the end of a
while $sth->fetchrow() loop.  DBI already knows you're done with it.
You only call finish if you break out of the loop.  Ask Tim.  He told
me personally :-)


В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Does copy abort on a failed insertion?
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Performance woes relating to DISTINCT (I think)