Re: [Tracker] file-meta.db-journal still constantly updated

[jamie <jamiemcc blueyonder co uk>]

On Thu, 2007-09-27 at 20:55 +0000, 5uj34k502 sneakemail com wrote:
> Thanks for the 0.6.3 update, which fixed the CPU hogging issue. I am however still wondering why (once 
> indexing is done) the file-meta.db-journal is constantly being written to, even though I am adding no new 
> files. file-meta.db by itself is not growing at all, but being constantly touched. This is using the SVN 
> version from the 26th. 
>
> As a workaround I've made file-meta.db read-only, and now it is no longer constantly writing to the journal 
> file.


wont work

we are not constantly writing to it - we do start a transaction on the
sqlite databases when the index thread is woken up (this creates the
journal files)

this should not cause any problems though as the transaction is closed
when the index thread goes back to sleep and the journal dissapears even
though nothing was written to the db

it should not be a performance issue at all?

jamie