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 RAA09501; Mon, 19 Apr 2004 17:52:56 +0200 (MET DST) 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 RAA09489 for ; Mon, 19 Apr 2004 17:52:55 +0200 (MET DST) Received: from pob.cs.unibo.it (pob.cs.unibo.it [130.136.10.114]) by nez-perce.inria.fr (8.12.10/8.12.10) with ESMTP id i3JFs1jq023145 for ; Mon, 19 Apr 2004 17:54:01 +0200 Received: from le1.cs.unibo.it (backle.cs.unibo.it [130.136.10.110]) by pob.cs.unibo.it (Postfix) with ESMTP id 088FB2A7DA for ; Mon, 19 Apr 2004 17:52:26 +0200 (CEST) Received: from fistandantilus.takhisis.org (n32d163.cs.unibo.it [130.136.32.163]) by le1.cs.unibo.it (8.9.3p2/8.9.3/Debian 8.9.3-21) with ESMTP id RAA16754 for ; Mon, 19 Apr 2004 17:52:06 +0200 X-Authentication-Warning: le1.cs.unibo.it: Host n32d163.cs.unibo.it [130.136.32.163] claimed to be fistandantilus.takhisis.org Received: by fistandantilus.takhisis.org (Postfix, from userid 3148) id 87A9B27409D; Mon, 19 Apr 2004 17:52:13 +0200 (CEST) Date: Mon, 19 Apr 2004 17:52:13 +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: <20040419155213.GC5121@fistandantilus.takhisis.org> Mail-Followup-To: caml-list@inria.fr References: <20040418161002.GA1468@fistandantilus.takhisis.org> <004d01c42621$591c7530$71010a0a@merann.ru> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <004d01c42621$591c7530$71010a0a@merann.ru> 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 0400,:01 bononia:01 trivial:01 bologna:03 wrote:03 zacchiroli:03 zacchiroli:03 unibo:03 zack:03 zack:03 bunch:03 stefano:04 Sender: owner-caml-list@pauillac.inria.fr Precedence: bulk On Mon, Apr 19, 2004 at 07:16:54PM +0400, Mikhail Fedotov wrote: > A trivial suggestion, but this usually comes from absence of > indexes or sql queries which fail to use existing indexes. I.e. I've indexes and I'm almost sure they were used since performances with or without them are significantly different. Anyway this discussion is starting to be too much OT for this list. I will move it to the sqlite ML. Sorry for the noise. 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