which fastest? name sql_calc_found_rows `table`, name count(*)
when border array rows returned sql query, wholly used paging, there twin methods establish sum array records:
method 1
include sql_calc_found_rows
choice uncanny select
, following sum array rows controlling select found_rows()
:
select sql_calc_found_rows * list where id > 100 border 10;
select found_rows();
method 2
run query normally, following sum array rows controlling select count(*)
select * list where id > 100 border 10;
select count(*) list where id > 100;
which slight best / fastest?
Comments
Post a Comment