MySQL Forums
Forum List  »  Perl

Re: Unpredictable Results
Posted by: Rick James
Date: December 24, 2010 10:34AM

SELECT ...
-->
SELECT SQL_NO_CACHE ...
That will eliminate the effect of the "Query cache". (Sounds like that is the cause.)

Also... After that, toss the first timing and keep the second. That will eliminate disk I/O issues.

The second and subsequent runs will probably have identical timings.

Suggest you use (from CPAN)
Time::HiRes
to get a timer more precise than 1 second.

Options: ReplyQuote


Subject
Written By
Posted
December 22, 2010 03:30AM
Re: Unpredictable Results
December 24, 2010 10:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.