List:Internals« Previous MessageNext Message »
From:Michael Widenius Date:November 11 2001 9:48pm
Subject:Re: Efficienty issue with SQL_CALC_FOUND_ROWS in mysql 4.0
View as plain text  
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
Thread
Efficienty issue with SQL_CALC_FOUND_ROWS in mysql 4.0Fournier Jocelyn [Presence-PC]8 Nov
  • Efficienty issue with SQL_CALC_FOUND_ROWS in mysql 4.0Michael Widenius9 Nov
    • Re: Efficienty issue with SQL_CALC_FOUND_ROWS in mysql 4.0Steve Meyers9 Nov
  • Re: Efficienty issue with SQL_CALC_FOUND_ROWS in mysql 4.0Fournier Jocelyn [Presence-PC]9 Nov
    • Re: Efficienty issue with SQL_CALC_FOUND_ROWS in mysql 4.0Sinisa Milivojevic9 Nov
      • Re: Efficienty issue with SQL_CALC_FOUND_ROWS in mysql 4.0Michael Widenius12 Nov