On Fri, 2007-10-12 at 13:08 +0100, Ash Berlin wrote: > Hartmaier Alexander wrote: > > Zero time sql! > > Sounds like a Whoracle feature for version 12! > > Or the next big thing for Damian Conway after his this year's YAPC::EU > > talk... > > > > -Alex > > > > Zero time was last years (or further back.) This year was negative time. > Or does that make it last year's was negative time. Or maybe the year > before that...... > > On a more serious note, Jon: 0.00 implies that MySQL (client) has cached > that query.
No no, in this case it means the query took less than 0.005 seconds as the MySQL client rounds to 2 decimal places. Have a read of the timings in the original post: DBI operation with prefetch took 0.000979 secs DBI operation without prefetch took 0.000793 secs Repeat DBI operation with prefetch took 0.000762 secs Inspect the code if you like; it was attached to the earlier post. -- Jon _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]
