On 2015-07-27 04:29 PM, rotaiv wrote: >> ?WOW! That is an amazing difference. Makes me glad that I'm OCD about >> staying relatively current. And please ignore my previous post. I somehow >> managed to not register that you would doing a LEFT join, an equi-join.? >> > I am also OCD about updates. I installed Sqlite using yum right before I > tried this test. I guess CentOS release 6.6 is not using the latest > version just yet. I would never have believed a new version would have had > such a dramatic difference.
It's not the older SQLite taking so much longer, it's simply that the file created with a newer SQLite probably contains a SCHEMA or objects not readily understood or able to be optimized by the older engine. if the file was made with the old engine it would perform perfectly well in both the old and new engines. Either that, or a bug that's been fixed since then. Have a great day, Ryan
