← Back to team overview

maria-developers team mailing list archive

Re: Optimization about count(*) of mysql 5.1.38


Hi, Lichao!

On Jan 24, Lichao Xie wrote:
> Hi, Sergei!
> I'm sorry, my English is not so good!
> There is no a API to get the exact records in a range, but the API can
> help to improve performance for the case: select count(*) from t where
> id > 10 and id < 1000000;
> I want to know why there is no such a API.

Because we did not need it so far - no engine had it.

And because the set of queries that it can optimize is pretty small, so
it most cases this feature is not worth implementing.


Follow ups