Re: (ITS#7667) performance degradation when using MDB_INTEGERKEY

--001a11c1e98008372804e46726c2 Content-Type: text/plain; charset=UTF-8 Hi, I extracted a small dataset that shows the problem. you can download it from here: https://docs.google.com/file/d/0B6o29pwkWoERdnFSaUtMNDljemc/edit?usp=sharing I modified mdb_copy.c to demonstrate the difference. copy it to source dir from here https://docs.google.com/file/d/0B6o29pwkWoERd3VuUm1DN0FpcUU/edit?usp=sharing build and run "time ./mdb_copy foo foo2" after this change the flag at line 64 and run it again. at my computer the difference is 17s vs 1.7s for 3 million items. On Tue, Aug 20, 2013 at 9:04 PM, Quanah Gibson-Mount <quanah(a)zimbra.com&gt;wrote: -- Best regards, Roman --001a11c1e98008372804e46726c2 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr"><div>Hi, I extracted a small dataset that shows the proble= m.</div><div>you can download it from here: <a href=3D"https://docs.google.= com/file/d/0B6o29pwkWoERdnFSaUtMNDljemc/edit?usp=3Dsharing">https://docs.go= ogle.com/file/d/0B6o29pwkWoERdnFSaUtMNDljemc/edit?usp=3Dsharing</a>... <div><br></div><div>I modified mdb_copy.c to demonstrate the difference. co= py it to source dir from here <a href=3D"https://docs.google.com/file/d/0B6= o29pwkWoERd3VuUm1DN0FpcUU/edit?usp=3Dsharing">https://docs.google... d/0B6o29pwkWoERd3VuUm1DN0FpcUU/edit?usp=3Dsharing</a></div> <div><br></div><div>build and=C2=A0</div><div>run &quot;time ./mdb_copy foo= foo2&quot;</div><div>after this change the flag at line 64 and run it agai= n.</div><div>at my computer the difference is 17s vs 1.7s for 3 million ite= ms.</div> <div><br></div></div><div class=3D"gmail_extra"><br><br><div class=3D"gmail= _quote">On Tue, Aug 20, 2013 at 9:04 PM, Quanah Gibson-Mount <span dir=3D"l= tr">&lt;<a href=3D"mailto:quanah@zimbra.com" target=3D"_blank">quanah@zimbr= a.com</a>&gt;</span> wrote:<br> <blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p= x #ccc solid;padding-left:1ex">--On Sunday, August 18, <a href=3D"tel:2013"= value=3D"+9722013" target=3D"_blank">2013</a> 11:46 AM +0000 <a href=3D"ma= ilto:romange@gmail.com" target=3D&quot;_blank&quot;&gt;romange(a)gmail.com&lt;/a&gt; wrote:<br> <br> <blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p= x #ccc solid;padding-left:1ex"> Full_Name: Roman Gershman<br> Version:<br> OS: linux 3.8.0-25-generic<br> URL:<br> Submission from: (NULL) (212.150.97.210)<br> </blockquote> <br> Please provide further information, specifically:<br> <br> The size of values<br> Insert order<br> Sample code if possible<br> <br> Thanks,<br> Quanah<br> <br> <br> --<br> <br> Quanah Gibson-Mount<br> Lead Engineer<br> Zimbra, Inc<br> --------------------<br> Zimbra :: =C2=A0the leader in open source messaging and collaboration<br> </blockquote></div><br><br clear=3D"all"><div><br></div>-- <br>Best regards= ,<br>=C2=A0 =C2=A0=C2=A0 Roman </div> --001a11c1e98008372804e46726c2--