Re: sqlite performance [was Re: [Caml-list] [announce] ocaml-sqlite 0.3.5]

[Stefano Zacchiroli <zack@bononia.it>]

On Fri, Apr 16, 2004 at 08:00:14PM -0700, Evan Martin wrote:
> But more simply and importantly, SQLite only commits to the file when a
> transaction is completed.  (There's an implicit transaction around every
> INSERT / UPDATE, etc. if you don't specify a transaction yourself.)
> I've seen significant performance increases by wrapping repeated
> modifications of large datasets with transactions (by using the SQL
> statements "BEGIN;" and "END;"), which allows the disk access to be

I've read this FAQ before on the sqlite site, but it doesn't apply to my
case: I've a database which is static, it is built from scratch from
time to time and I simply need to perform a lot of SELECT on the db.

Cheers.

-- 
Stefano Zacchiroli -*- Computer Science PhD student @ Uny Bologna, Italy
zack@{cs.unibo.it,debian.org,bononia.it} -%- http://www.bononia.it/zack/
If there's any real truth it's that the entire multidimensional infinity
of the Universe is almost certainly being run by a bunch of maniacs. -!-

-------------------
To unsubscribe, mail caml-list-request@inria.fr Archives: http://caml.inria.fr
Bug reports: http://caml.inria.fr/bin/caml-bugs FAQ: http://caml.inria.fr/FAQ/
Beginner's list: http://groups.yahoo.com/group/ocaml_beginners