[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Monotone-devel] Monotone speedup by adding additional database indi

From: Ralf S. Engelschall
Subject: Re: [Monotone-devel] Monotone speedup by adding additional database indices?
Date: Thu, 11 Oct 2007 08:11:04 +0200
User-agent: Mutt/1.5.16 OpenPKG/CURRENT (2007-06-09)

On Wed, Oct 10, 2007, Bruce Stephens wrote:

> Chad Walstrom <address@hidden> writes:
> [...]
> > Would there be a way to tell sqlite to ignore indices for given
> > operations, such as pulls?
> That strikes me as a low-level question that should be ignored (at
> least unless it causes some measurable problem).
> One would hope that SQLite will only (or mostly, anyway) use indexes
> when they'll be beneficial.  Index updates strike me as more likely to
> be a problem, but I doubt it makes sense to suggest sometimes not
> updating indexes.

SQLite has a sufficient optimizer and uses indices only where it really
makes sense. See for some
                                       Ralf S. Engelschall

reply via email to

[Prev in Thread] Current Thread [Next in Thread]