Re: [sqlite] Big performance regressions since 3.4.0?

2009-01-05 Thread Jason Freund
ON; CREATE TABLE _CATEGORY( CategoryLUID integer not null primary key default 1, Name text not null, ReadOnly int not null ); CREATE TABLE _CATEGORY_MEMBERSHIP( CategoryMemberLUID integer not null primary key default 1, CategoryLUID integer not null, E

[sqlite] Big performance regressions since 3.4.0?

2008-12-24 Thread Jason Freund
Hi, We recently upgraded from 3.4.0 to 3.6.5, and noticed that our little, internal sqlite benchmark test program performed much worse on most operations with the new version. We expected to see an improvement because 3.6.1 advertises a performance enhancement with the lookaside buffer.