<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Monospaced;
        panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
span.EmailStyle17
        {mso-style-type:personal-compose;
        font-family:"Calibri","sans-serif";
        color:windowtext;}
span.apple-converted-space
        {mso-style-name:apple-converted-space;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-family:"Calibri","sans-serif";}
@page WordSection1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><o:p>&nbsp;</o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Julian had mentioned to me a few times how much faster the test suite is with MySQL caching.&nbsp; Everyone else may have already known this, but I just found out that it&#8217;s not enabled by default.&nbsp; You can see how much space is allocated with the following.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>&nbsp;<o:p></o:p></span></p><p class=MsoNormal style='text-indent:.5in'><b><span style='font-size:7.0pt;font-family:Monospaced;color:blue'>SHOW VARIABLES LIKE<span class=apple-converted-space>&nbsp;</span></span></b><span style='font-size:7.0pt;font-family:Monospaced;color:red'>'query_cache_size'</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:Monospaced'>&nbsp;</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>You can set it with<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:Monospaced'>&nbsp;</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><o:p></o:p></span></p><p class=MsoNormal style='text-indent:.5in'><b><span style='font-size:7.0pt;font-family:Monospaced;color:#8000FF'>SET<span class=apple-converted-space>&nbsp;</span></span></b><b><span style='font-size:7.0pt;font-family:Monospaced;color:blue'>GLOBAL<span class=apple-converted-space>&nbsp;</span></span></b><span style='font-size:7.0pt;font-family:Monospaced'>query_cache_size =<span class=apple-converted-space>&nbsp;</span><span style='color:fuchsia'>NNN</span></span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:Monospaced'>&nbsp;</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>I bumped mine from 0 to 32 meg, and that dropped my test run time from around 16-17 minutes to just under 6 minutes after the first run.&nbsp; Very nice.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><o:p>&nbsp;</o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Oracle 11 also supports result set caching.&nbsp; You can determine your current settings with<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>&nbsp;<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-family:Monospaced'>&nbsp;</span><b><span style='font-size:7.0pt;font-family:Monospaced;color:blue'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></b><span style='font-size:7.0pt;font-family:Monospaced;color:black'>&nbsp; </span><b><span style='font-size:7.0pt;font-family:Monospaced;color:blue'>SELECT name</span></b><span style='font-size:7.0pt;font-family:Monospaced;color:black'>, </span><b><span style='font-size:7.0pt;font-family:Monospaced;color:blue'>value</span></b><span style='font-size:7.0pt;font-family:Monospaced;color:black'>, isdefault</span><span style='font-family:Monospaced'><o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:7.0pt;font-family:Monospaced;color:black'>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span style='font-size:7.0pt;font-family:Monospaced;color:blue'>FROM </span></b><span style='font-size:7.0pt;font-family:Monospaced;color:black'>&nbsp;&nbsp;v$parameter</span><span style='font-family:Monospaced'><o:p></o:p></span></p><p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span style='font-size:7.0pt;font-family:Monospaced;color:black'>&nbsp;&nbsp; &nbsp;</span><b><span style='font-size:7.0pt;font-family:Monospaced;color:blue'>WHERE </span></b><span style='font-size:7.0pt;font-family:Monospaced;color:black'>&nbsp;</span><b><span style='font-size:7.0pt;font-family:Monospaced;color:blue'>name LIKE </span></b><span style='font-size:7.0pt;font-family:Monospaced;color:red'>'result_cache%'</span><span style='font-family:Monospaced'><o:p></o:p></span></p><p class=MsoNormal><b><span style='font-size:7.0pt;font-family:Monospaced;color:#46B13B'><o:p>&nbsp;</o:p></span></b></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>And change allocated size with</span><b><span style='font-size:7.0pt;font-family:Monospaced;color:#46B13B'><o:p></o:p></span></b></p><p class=MsoNormal style='text-autospace:none'><span style='font-family:Monospaced'><o:p>&nbsp;</o:p></span></p><p class=MsoNormal style='text-indent:.5in;text-autospace:none'><b><span style='font-size:7.0pt;font-family:Monospaced;color:blue'>ALTER SYSTEM SET </span></b><span style='font-size:7.0pt;font-family:Monospaced;color:black'>result_cache_max_size = 2M </span><b><span style='font-size:7.0pt;font-family:Monospaced;color:blue'>SCOPE </span></b><span style='font-size:7.0pt;font-family:Monospaced;color:black'>= MEMORY</span><span style='font-family:Monospaced'><o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><b><span style='font-size:7.0pt;font-family:Monospaced;color:#46B13B'><o:p>&nbsp;</o:p></span></b></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>The other key thing to be aware of is that by default Oracle will only use caching if there is a hint in the query (or I think with a connection param).&nbsp; To force it to always try to use result set caching set the following parameter:</span><b><span style='font-size:7.0pt;font-family:Monospaced;color:#46B13B'><o:p></o:p></span></b></p><p class=MsoNormal style='text-autospace:none'><span style='font-family:Monospaced'><o:p>&nbsp;</o:p></span></p><p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span style='font-size:7.0pt;font-family:Monospaced;color:black'> </span><b><span style='font-size:7.0pt;font-family:Monospaced;color:blue'>ALTER SESSION SET </span></b><span style='font-size:7.0pt;font-family:Monospaced;color:black'>result_cache_mode = </span><b><span style='font-size:7.0pt;font-family:Monospaced;color:blue'>FORCE</span></b><span style='font-family:Monospaced'><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:Monospaced'><o:p>&nbsp;</o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><o:p>&nbsp;</o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><o:p>&nbsp;</o:p></span></p></div></body></html>