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.
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.