From: Date: January 3 2008 8:41pm Subject: Re: what should an assert_efficient_sql check for? List-Archive: http://lists.mysql.com/internals/35257 Message-Id: <4cfa0b030801031141yfb7a071xc45c0530f190f40e@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On Jan 3, 2008 2:21 PM, 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? No, it's just that the 'rows' is an estimate based on storage engine statistics, and is wrong. (I'm guessing you're looking at InnoDB tables).