From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from mo-p00-ob.rzone.de (mo-p00-ob.rzone.de [81.169.146.161]) by krisdoz.my.domain (8.14.5/8.14.5) with ESMTP id q57GTFbB006171 for ; Thu, 7 Jun 2012 12:29:16 -0400 (EDT) X-RZG-AUTH: :JiIXek6mfvEEUpFQdo7Fj1/zg48CFjWjQv0cW+St/nW/auYssSp3kjSqZ1G5Bg== X-RZG-CLASS-ID: mo00 Received: from britannica.bec.de (ip-2-207-50-201.web.vodafone.de [2.207.50.201]) by smtp.strato.de (jored mo52) (RZmta 29.10 DYNA|AUTH) with (AES128-SHA encrypted) ESMTPA id B07555o57F3Agv for ; Thu, 7 Jun 2012 18:29:12 +0200 (CEST) Received: by britannica.bec.de (sSMTP sendmail emulation); Thu, 07 Jun 2012 18:29:09 +0200 Date: Thu, 7 Jun 2012 18:29:09 +0200 From: Joerg Sonnenberger To: tech@mdocml.bsd.lv Subject: Re: mandocdb tools, sqlite3, and ohash Message-ID: <20120607162909.GA3020@britannica.bec.de> Mail-Followup-To: tech@mdocml.bsd.lv References: <4FD0C58C.5040104@bsd.lv> X-Mailinglist: mdocml-tech Reply-To: tech@mdocml.bsd.lv MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4FD0C58C.5040104@bsd.lv> User-Agent: Mutt/1.5.21 (2010-09-15) On Thu, Jun 07, 2012 at 05:15:24PM +0200, Kristaps Dzonsons wrote: > The biggest bottleneck right now is the database. Try running > mandocdb with -n to see the magnitude of difference. Ugh! The -n > is checked directly prior to database stuff ("nodb" in the source), > so there's little else going on there. I don't do any fancy sqlitey > stuff, so there's room for improvement. Well, don't do a commit per page. That's forcing a sync per page, no wonder it is slow. Joerg -- To unsubscribe send an email to tech+unsubscribe@mdocml.bsd.lv