> 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. >
Originally, I copied the database file from my PC to my Linux server. I thought it might be a carriage return or line feed issue so I recreated the database from scratch on my Linux server. Didn't change anything. > Either that, or a bug that's been fixed since then. > I'm thinking a bug or they significantly improved the selection statement code!