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);