Re: [sqlite] Performance of a SELECT DISTINCT query, then vs now

2010-02-15 Thread exarkun
As usual, I forgot the promised attachments. Here they are. Jean-Paul addr opcode p1 p2 p3 -- -- -- - 0 Noop0 0 1 Integer 2 0 2 MustBeInt

[sqlite] Performance of a SELECT DISTINCT query, then vs now

2010-02-15 Thread exarkun
Hi all, I'm investigating some apparent slowdowns of an app when upgrading to more recent versions of SQLite3. This has been a problem for quite a while, so I had to go back pretty far to find a version of SQLite3 where things were performing as desired. For the moment, I've just compared 3.