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

From: Chris <dmagick(at)gmail(dot)com>
To: Silas Justiniano <silasju(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Insert more than one t-uple in a single sql
Date: 2006-02-12 23:57:14
Message-ID: 43EFCB5A.4060009@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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);

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ken Winter 2006-02-13 01:21:49 Re: Why does an ON SELECT rule have to be named "_RETURN"?
Previous Message Bruce Momjian 2006-02-12 23:56:15 Re: [GENERAL] Number format problem