From mboxrd@z Thu Jan 1 00:00:00 1970 Received: (from majordomo@localhost) by pauillac.inria.fr (8.7.6/8.7.3) id SAA27657; Sun, 18 Apr 2004 18:10:14 +0200 (MET DST) X-Authentication-Warning: pauillac.inria.fr: majordomo set sender to owner-caml-list@pauillac.inria.fr using -f Received: from nez-perce.inria.fr (nez-perce.inria.fr [192.93.2.78]) by pauillac.inria.fr (8.7.6/8.7.3) with ESMTP id SAA28792 for ; Sun, 18 Apr 2004 18:10:13 +0200 (MET DST) Received: from ms003msg.fastwebnet.it (ms003msg.fastwebnet.it [213.140.2.42]) by nez-perce.inria.fr (8.12.10/8.12.10) with ESMTP id i3IGBIjq029091 for ; Sun, 18 Apr 2004 18:11:18 +0200 Received: from dalamar.takhisis.org (37.10.140.106) by ms003msg.fastwebnet.it (6.7.019) id 40586384009E2C16 for caml-list@inria.fr; Sun, 18 Apr 2004 18:10:11 +0200 Received: from fistandantilus.takhisis.org (fistandantilus.takhisis.org [192.168.1.113]) by dalamar.takhisis.org (Postfix) with ESMTP id 090DFB7C7 for ; Sun, 18 Apr 2004 18:10:34 +0200 (CEST) Received: by fistandantilus.takhisis.org (Postfix, from userid 3148) id 8EB232744C1; Sun, 18 Apr 2004 18:10:02 +0200 (CEST) Date: Sun, 18 Apr 2004 18:10:02 +0200 From: Stefano Zacchiroli To: caml-list@inria.fr Subject: Re: sqlite performance [was Re: [Caml-list] [announce] ocaml-sqlite 0.3.5] Message-ID: <20040418161002.GA1468@fistandantilus.takhisis.org> Mail-Followup-To: caml-list@inria.fr References: <20040414221612.GA21960@danga.com> <20040415095104.GA5908@fistandantilus.takhisis.org> <20040415134438.GB28237@excelhustler.com> <20040415135311.GA1441@fistandantilus.takhisis.org> <20040417030014.GA14011@lulu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20040417030014.GA14011@lulu> User-Agent: Mutt/1.5.5.1+cvs20040105i X-Miltered: at nez-perce by Joe's j-chkmail ("http://j-chkmail.ensmp.fr")! X-Loop: caml-list@inria.fr X-Spam: no; 0.00; bononia:01 caml-list:01 2004:99 evan:01 datasets:01 faq:01 bononia:01 0700,:01 implicit:02 bologna:03 wrote:03 zacchiroli:03 zacchiroli:03 unibo:03 zack:03 Sender: owner-caml-list@pauillac.inria.fr Precedence: bulk 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