Hi Stefan,<br>      If monetdb doesn&#39;t maintain any caching then when i am creating test1 database<br>which contain demo table which contain <span style="background-color:rgb(255,255,0)">100 million records</span>.<br>
<br>When first time i am executing<span style="background-color:rgb(153,255,255)"> &quot;SELECT SUM(V1) FROM DEMO;&quot;</span><br>monetdb gives me <span style="background-color:rgb(255,255,0)">result in (11.4s)</span><br>
when immediate i am trying to execute same query &quot;SELECT SUM(V1) FROM DEMO;&quot;<br>It gives me <span style="background-color:rgb(255,255,0)">result in (31.065ms)</span><br><br>How / why this happen?<br><br><span style="background-color:rgb(255,204,153)">I have also checked my OS memory cache and I have erased OS Memory cache.</span><br>
Now, I am trying same query &quot;SELECT SUM(V1) FROM DEMO;&quot;<br>now also he take same time in <span style="background-color:rgb(255,255,0)">milliseconds approximate(30.723ms)</span><br><br>why he first time take lot of time and every next time he take negligible time. <br>
<br>I hope you will clear my problem related of throughput time. <br clear="all"><br>-- <br>Regards,<br>Swapnil K. Joshi<br><br>