Re: Efficienty issue with SQL_CALC_FOUND_ROWS in mysql 4.0

[Michael Widenius]

Hi!

>>>>> "Sinisa" == Sinisa Milivojevic <sinisa@stripped> writes:

Sinisa> On Fri, 9 Nov 2001 10:04:04 +0100
Sinisa> "Fournier Jocelyn [Presence-PC]" <joc@stripped> wrote:

>> Hi,
>> 
>> Yes, but why SQL_CALC_FOUND_ROWS couldn't use the internal MyISAM counter to
>> get the number of row of the table in this particular query ?
>> 
>> Regards,
>> Jocelyn
>> 

Sinisa> Hi!

Sinisa> This option has to work with any table type, not just MyISAM.

Sinisa> But still, if it is a query on one table without grouping or filtering, this
> could be a possible optimisation. 

Sinisa> Monty, do I put it on my TODO ??

Yes, please.

Regards,
Monty