On 5/1/06, Ivan Voras <[EMAIL PROTECTED]> wrote:
I've spent a long time debugging low performance of an application that uses :memory: database and have found that sqlite v2 is much faster than v3. After some digging around it seems that even two proof-of-concept programs that are identical except for used SQLite version reproduce this behaviour just fine:
Testing is difficult to do correctly. As several people noted on this list just today the first time they ran a query it had much different performance than subsequent runs of the query. Did you run these tests more than one time? What's your environment?
