← Back to team overview

maria-developers team mailing list archive

Re: Optimization about count(*) of mysql 5.1.38

 

Hi, Lichao!

On Jan 21, Lichao Xie wrote:
> >
> > No, there is no such a API. The best you can do in your engine is to pay
> > attention to TABLE::read_set and HA_EXTRA_KEYREAD which will allow you
> > to reduce the amount of work you do per key. But still it will be the
> > complete range scan - from the lower to the upper boundary or the range.
> 
> Yes. But I want to know that with this use is based on what consideration?
> the lock or something else?

I am sorry, I cannot understand you.
Could you try to rephrase your question please?

Regards,
Sergei



Follow ups

References