From: Date: January 3 2008 8:44pm
Subject: Re: what should an assert_efficient_sql check for?
List-Archive: http://lists.mysql.com/internals/35258
Message-Id: <477D3B0A.2010509@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Phlip wrote:
>>     10000 < explanation['rows'] ) ||
> 
> Curiously, why would a select-all over 1535 records return 1164 rows?
> 
> Is that just because >300 were already buffered in memory?

I squeezed in a FLUSH TABLES, and got 185 row hits for 185 records, so that's 
quite the "yes".

I will add FLUSH TABLES to the top of the assertion, to avoid any unnecessary 
efficiencies.