On Wed, Oct 10, 2007, Bruce Stephens wrote: > Chad Walstrom <[EMAIL PROTECTED]> 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 http://www.sqlite.org/optoverview.html for some details. Ralf S. Engelschall [EMAIL PROTECTED] www.engelschall.com _______________________________________________ Monotone-devel mailing list [email protected] http://lists.nongnu.org/mailman/listinfo/monotone-devel
