CODEWITHSUNDEEP
mysqlperformance
Mask
Mask

Reputation: 34207

Is it possible to get count(*) and * more efficiently?

I'm now running two queries,which is not so efficient I think:

select count(*) from table where id>0;
select * from table where id>0 limit 10;

Upvotes: 0

Views: 148

Answers (2)

Frankie
Frankie

Reputation: 25165

If you are using PHP just run mysql_num_rows on the query.

$query = mysql_query("SELECT * FROM ... WHERE ...");
$rows = mysql_num_rows($query);

Upvotes: 1

Asaph
Asaph

Reputation: 162831

You can do it using SQL_CALC_FOUND_ROWS.

SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name WHERE id > 100 LIMIT 10;
SELECT FOUND_ROWS();

But check out this blog entry about the performance of SQL_CALC_FOUND_ROWS.

Upvotes: 2

Related Questions