Re: [sqlite] 'DatabaseError: database disk image is malformed'

2010-04-10 Thread exarkun
On 02:21 pm, rut...@cs.vu.nl wrote: >[I first posted this on the Trac user list. There, I was referred to >the >sqlite mailing lists.] > >I am running 3 trac instances on a FreeBSD server; trac 0.11b, sqlite3 >3.4.1, pysqlite-2.3.5. More or less simultaneously (at least within a >few days) all

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