Re: Insert more than one t-uple in a single sql

Поиск
Список
Период
Сортировка
От Chris
Тема Re: Insert more than one t-uple in a single sql
Дата
Msg-id 43EFCB5A.4060009@gmail.com
обсуждение исходный текст
Ответ на Re: Insert more than one t-uple in a single sql  ("Silas Justiniano" <silasju@gmail.com>)
Список pgsql-general
What happens if that query returns 5,000 rows?

Postgres does actually have to fetch all of those rows, and then php has
to allocate memory etc to store them.

It's not very efficient.

Silas Justiniano wrote:
> Thank you very much. But what do you think of:
>
> select foobar from table where <condition>;
> if (pgsql_num_rows($result) > 15) show_pages;
> show_only_15($result);


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Why does an ON SELECT rule have to be named "_RETURN"?
Следующее
От: "Ken Winter"
Дата:
Сообщение: Re: Why does an ON SELECT rule have to be named "_RETURN"?