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 RAA04236; Mon, 19 Apr 2004 17:16:58 +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 RAA04225 for ; Mon, 19 Apr 2004 17:16:56 +0200 (MET DST) Received: from mail.mera.ru (mail.mera.ru [195.98.57.161]) by nez-perce.inria.fr (8.12.10/8.12.10) with ESMTP id i3JFI2jq018240 for ; Mon, 19 Apr 2004 17:18:03 +0200 Received: from drweb by mail.mera.ru with drweb-scanned (Exim 4.22) id 1BFaVy-000NlG-Hh; Mon, 19 Apr 2004 19:16:54 +0400 Received: from mp5-sd6.merann.ru ([10.10.1.113] helo=mp5sd6) by mail.mera.ru with esmtp (Exim 4.22) id 1BFaVy-000NlA-AN; Mon, 19 Apr 2004 19:16:54 +0400 From: "Mikhail Fedotov" To: "'Stefano Zacchiroli'" , Subject: RE: sqlite performance [was Re: [Caml-list] [announce] ocaml-sqlite 0.3.5] Date: Mon, 19 Apr 2004 19:16:54 +0400 Message-ID: <004d01c42621$591c7530$71010a0a@merann.ru> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4510 In-Reply-To: <20040418161002.GA1468@fistandantilus.takhisis.org> Importance: Normal 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; caml-list:01 datasets:01 faq:01 trivial:01 implicit:02 compiled:05 static:06 suggestion:06 scratch:06 specify:06 site:91 i've:09 i've:09 virtual:10 built:10 Sender: owner-caml-list@pauillac.inria.fr Precedence: bulk Hi, >> 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. A trivial suggestion, but this usually comes from absence of indexes or sql queries which fail to use existing indexes. I.e. you have a good reason to check how your sql queries are compiled into sqlite virtual machine instructions. This was discussed in the sqlite list from time to time. Mikhail ------------------- 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