03.03.2016 17:13, Dmitry Yemanov wrote: > Can you perform the same test but with INT join key?
I made number of records in table i2 four times bigger to get rid of timer's jitter, but still... Original: > SQL> select count(*) from i1 join i2 on i1.a=i2.a; > > PLAN HASH (I2 NATURAL, I1 NATURAL) > > COUNT > ===================== > 72 > > Current memory = 342876528 > Delta memory = 0 > Max memory = 342959008 > Elapsed time= 1.243 sec > Buffers = 40000 > Reads = 0 > Writes = 0 > Fetches = 659455 CRC32: > SQL> select count(*) from i1 join i2 on i1.a=i2.a; > > PLAN HASH (I2 NATURAL, I1 NATURAL) > > COUNT > ===================== > 72 > > Current memory = 354130256 > Delta memory = 0 > Max memory = 354217800 > Elapsed time= 1.238 sec > Buffers = 40000 > Reads = 0 > Writes = 0 > Fetches = 659455 -- WBR, SD. ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
