List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:July 30 1999 10:05pm
Subject:RE: Count(*) definitely slower than select col and count num rows combo
View as plain text  
>>>>> "Steven" == Steven Roussey <sroussey@stripped>
> writes:

Steven> And they said cut/copy/paste was easy!
Steven> Type 1: average query time is is 0.15165980696678 seconds with max of
Steven> 9.3659509420395 seconds
Steven> Type 2: average query time is is 0.2846958220005 seconds with max of
Steven> 5.8125519752502 seconds
Steven> Type 3: average query time is is 0.2899955201149 seconds with max of
Steven> 0.71884989738464 seconds

Steven> I fixed the decimal spot above. Yikes. That's what I get for trying to
Steven> nicely format the test results. Thanks for pointing this out!

Steven> Steven Roussey
Steven> Network54.com

Hi!

Could the MAX time be depending on that you where executing some update
that locked the table ?

Regards,
Monty
Thread
Count(*) definitely slower than select col and count num rows comboSteven Roussey18 Jul
  • Count(*) definitely slower than select col and count num rows combosinisa18 Jul
    • RE: Count(*) definitely slower than select col and count num rows comboSteven Roussey18 Jul
      • RE: Count(*) definitely slower than select col and count num rows combosinisa19 Jul
    • Re: Count(*) definitely slower than select col and count num rows comboSasha Pachev19 Jul
      • RE: Count(*) definitely slower than select col and count num rows comboSteven Roussey19 Jul
        • RE: Count(*) definitely slower than select col and count num rows comboMichael Widenius31 Jul
      • Re: Count(*) definitely slower than select col and count num rows combosinisa20 Jul
  • RE: Count(*) definitely slower than select col and count num rows comboSteven Roussey19 Jul
    • Re: Count(*) definitely slower than select col and count num rows comboJim Faucette19 Jul
      • RE: Count(*) definitely slower than select col and count num rows comboSteven Roussey19 Jul
        • RE: Count(*) definitely slower than select col and count num rows comboMichael Widenius31 Jul
    • RE: Count(*) definitely slower than select col and count num rows comboMichael Widenius31 Jul
  • Count(*) definitely slower than select col and count num rows comboMichael Widenius31 Jul