What's faster? - Mailing list pgsql-general

From Silas Justiniano
Subject What's faster?
Date
Msg-id 1139456715.177179.159300@o13g2000cwo.googlegroups.com
Whole thread Raw
Responses Re: What's faster?  (Chris <dmagick@gmail.com>)
Re: What's faster?  (Alban Hertroys <alban@magproductions.nl>)
Re: What's faster?  ("Uwe C. Schroeder" <uwe@oss4u.com>)
List pgsql-general
Hello all!

I'm performing a query that returns me hundreds of records... but I
need cut them in pages that have 15 items! (using PHP)

So, is it faster:

  select blablabal from _complex_query
  if (count($result) > 15) show_pages;
  show_only_15_rows($result);

or:

  select count(*) from _complex_query
  if ($result1 > 15) show_pages;
  select blablabal from _complex_query LIMIT ... (see the LIMIT!)
  show $result

On the first, I can use pg_num_rows instead of count(), too.

what do you think?

Thank you!


pgsql-general by date:

Previous
From: Rodolfo Campos
Date:
Subject: Re: Insert into other database
Next
From: Tom Lane
Date:
Subject: Re: Request to have VACUUM ignore cost based limits