Number of matches of a select

[salva]

Hi!
I make a select with a select clause and I limit it to 5 results, but
I need to know if there are more matches to enable a "next" link to
see the others
I've thought about not limiting it in the query but displaying only 5
results so I could know if there are more matches I don't display, but
maybe it's slower.
My question is: Is there any functon that retrieves the number of
matches without loading data to make the system faster?
Thanks

[Aggro]

salva wrote:

I've thought about not limiting it in the query but displaying only 5
results so I could know if there are more matches I don't display, but
maybe it's slower.
select * from tablename limit 6;

show only 5, and if the amount of returned rows is 6, you know there are
more left and you can do another query.
My question is: Is there any functon that retrieves the number of
matches without loading data to make the system faster?

Or...

select count(*) from tablename;

which will return a number of rows matching. Use this instead of the
first only if you are planning to show navigation buttons to jump bigger
steps between the results instead of just showing [back] and [next]. For
example:
[1-10] [11-20] [21-30] [31-40] etc.

Because the first one is most likely faster with limit 6 than making two
queries.