Re: [sqlite] About ticket #3452

2008-10-24 Thread Nicolas Williams
On Fri, Oct 24, 2008 at 03:10:30PM -0700, Roger Binns wrote: > Nicolas Williams wrote: > > I've not run Evolution with SQLite3, so I don't know if it shares the > > cache. I'll ask the user in question to check. > > You'll need to ask the developer :-) According to the user Evolution has been

Re: [sqlite] About ticket #3452

2008-10-24 Thread Nicolas Williams
On Thu, Oct 23, 2008 at 04:04:58PM -0700, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Nicolas Williams wrote: > > (FYI, Evolution has/had a separate performance problem in that it opens > > a SQLite3 DB handle for the same DB every time you open a mail folder, > >

Re: [sqlite] About ticket #3452

2008-10-23 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Nicolas Williams wrote: > (FYI, Evolution has/had a separate performance problem in that it opens > a SQLite3 DB handle for the same DB every time you open a mail folder, > whereas it could just re-use an existing open DB handle.) Why is that a

[sqlite] About ticket #3452

2008-10-23 Thread Nicolas Williams
I filed ticket #3452 the other day, worked up a patch. The patch does three things: - Adds a real unixSectorSize() implementation where fstatvfs(2) is available. The host filesystem's f_bsize will be returned instead of SQLITE_DEFAULT_SECTOR_SIZE. - Changes SQLITE_MAX_DEFAULT_PAGE_SIZE