[Monotone-devel] Re: why is monotone so slow?

[graydon hoare]

On Tue, 14 Sep 2004 17:14:37 +0200, Georg-W. Koltermann <address@hidden> wrote:

> I should have been more precise in my original question: Do you perhaps
> have a pointer to how I can tune sqlite?  Or a pointer to how I could
> replace it with sqlite3?  I am currently just playing, it would be no
> problem if you tell me to install another branch of monotone (which
> might have those improvements) and start importing my source afresh.

the page size constant is in pager.h. you can try tweaking that and
rebuilding, dumping old database and loading into a new one. or you
can try inserting some code to adjust db performance in the transaction
guard startup or database opening code (database.cc). there are some
PRAGMAs you can use listed in the language reference on the sqlite
website: http://www.sqlite.org/lang.html

sqlite 3 is supposed to do more runtime tuning, plus I'm planning on redoing
database.cc to use a pre-compiled statement cache (I have a sketch of this
mechanism already). afaik nobody has done a sqlite 3 branch yet. the
sqlite authors appear to be finishing their beta stage and transitioning
to a "stable" around a week from now. so it probably works ok now, you're
welcome to have a go at it!

-graydon