Version française
Home     About     Download     Resources     Contact us    

This site is updated infrequently. For up-to-date information, please visit the new OCaml website at

Browse thread
[Caml-list] [announce] ocaml-sqlite 0.3.5
[ Home ] [ Index: by date | by threads ]
[ Search: ]

[ Message by date: previous | next ] [ Message in thread: previous | next ] [ Thread: previous | next ]
Date: 2004-04-18 (16:10)
From: Stefano Zacchiroli <zack@b...>
Subject: Re: sqlite performance [was Re: [Caml-list] [announce] ocaml-sqlite 0.3.5]
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.


Stefano Zacchiroli -*- Computer Science PhD student @ Uny Bologna, Italy
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 Archives:
Bug reports: FAQ:
Beginner's list: