From unknown Sat Jun 14 23:18:38 2025 X-Loop: help-debbugs@gnu.org Subject: [bug#32209] [PATCH] database: Use SQLite in Multi-thread mode. Resent-From: =?UTF-8?Q?Cl=C3=A9ment?= Lassieur Original-Sender: "Debbugs-submit" Resent-CC: guix-patches@gnu.org Resent-Date: Thu, 19 Jul 2018 10:56:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 32209 X-GNU-PR-Package: guix-patches X-GNU-PR-Keywords: patch To: 32209@debbugs.gnu.org X-Debbugs-Original-To: guix-patches@gnu.org Received: via spool by submit@debbugs.gnu.org id=B.153199773713153 (code B ref -1); Thu, 19 Jul 2018 10:56:01 +0000 Received: (at submit) by debbugs.gnu.org; 19 Jul 2018 10:55:37 +0000 Received: from localhost ([127.0.0.1]:47548 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fg6au-0003Q4-Pd for submit@debbugs.gnu.org; Thu, 19 Jul 2018 06:55:37 -0400 Received: from eggs.gnu.org ([208.118.235.92]:49753) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fg6au-0003Pt-0i for submit@debbugs.gnu.org; Thu, 19 Jul 2018 06:55:36 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1fg6an-0005x0-4v for submit@debbugs.gnu.org; Thu, 19 Jul 2018 06:55:30 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=0.8 required=5.0 tests=BAYES_50 autolearn=disabled version=3.3.2 Received: from lists.gnu.org ([2001:4830:134:3::11]:37374) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1fg6am-0005wo-TD for submit@debbugs.gnu.org; Thu, 19 Jul 2018 06:55:29 -0400 Received: from eggs.gnu.org ([2001:4830:134:3::10]:40719) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1fg6ak-0007sH-O5 for guix-patches@gnu.org; Thu, 19 Jul 2018 06:55:28 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1fg6af-0005sp-Tn for guix-patches@gnu.org; Thu, 19 Jul 2018 06:55:26 -0400 Received: from mail.lassieur.org ([83.152.10.219]:59534) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1fg6af-0005nz-J1 for guix-patches@gnu.org; Thu, 19 Jul 2018 06:55:21 -0400 Received: from newt.Parrot.Biz (smtp.parrot.biz [62.23.167.188]) by mail.lassieur.org (OpenSMTPD) with ESMTPSA id df973103 (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256:NO) for ; Thu, 19 Jul 2018 10:55:17 +0000 (UTC) From: =?UTF-8?Q?Cl=C3=A9ment?= Lassieur Date: Thu, 19 Jul 2018 12:54:57 +0200 Message-Id: <20180719105457.32267-1-clement@lassieur.org> X-Mailer: git-send-email 2.18.0 X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] [fuzzy] X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x X-Received-From: 2001:4830:134:3::11 X-Spam-Score: -4.1 (----) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -5.1 (-----) This disables mutexing on database connection and prepared statement objects, thus making us responsible for serializing access to database connections and prepared statements. It may result in a performance improvement. * src/cuirass/database.scm (db-init, db-open): Pass the SQLITE_OPEN_NOMUTEX flag to SQLITE-OPEN. --- src/cuirass/database.scm | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) diff --git a/src/cuirass/database.scm b/src/cuirass/database.scm index a84d0fa..6bf3bc4 100644 --- a/src/cuirass/database.scm +++ b/src/cuirass/database.scm @@ -195,7 +195,8 @@ database object." (format (current-error-port) "Removing leftover database ~a~%" db-name) (delete-file db-name)) (let ((db (sqlite-open db-name (logior SQLITE_OPEN_CREATE - SQLITE_OPEN_READWRITE)))) + SQLITE_OPEN_READWRITE + SQLITE_OPEN_NOMUTEX)))) (db-load db schema) (db-set-schema-version db (latest-db-schema-version)) db)) @@ -222,7 +223,9 @@ database object." ;; avoid SQLITE_LOCKED errors when we have several readers: ;; . (set-db-options (if (file-exists? db) - (db-upgrade (sqlite-open db SQLITE_OPEN_READWRITE)) + (db-upgrade + (sqlite-open db (logior SQLITE_OPEN_READWRITE + SQLITE_OPEN_NOMUTEX))) (db-init db)))) (define (db-close db) -- 2.18.0 From debbugs-submit-bounces@debbugs.gnu.org Thu Jul 19 08:02:29 2018 Received: (at control) by debbugs.gnu.org; 19 Jul 2018 12:02:29 +0000 Received: from localhost ([127.0.0.1]:47584 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fg7dd-000733-Ki for submit@debbugs.gnu.org; Thu, 19 Jul 2018 08:02:29 -0400 Received: from mail.lassieur.org ([83.152.10.219]:49252) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fg7dc-00072v-FY for control@debbugs.gnu.org; Thu, 19 Jul 2018 08:02:28 -0400 Received: from newt (smtp.parrot.biz [62.23.167.188]) by mail.lassieur.org (OpenSMTPD) with ESMTPSA id a05d83c0 (TLSv1.2:ECDHE-RSA-CHACHA20-POLY1305:256:NO) for ; Thu, 19 Jul 2018 12:02:26 +0000 (UTC) Date: Thu, 19 Jul 2018 14:02:26 +0200 Message-Id: <87y3e75t7x.fsf@lassieur.org> To: control@debbugs.gnu.org From: clement@lassieur.org (=?utf-8?Q?Cl=C3=A9ment?= Lassieur) Subject: control message for bug #32209 MIME-version: 1.0 Content-type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Spam-Score: -0.0 (/) X-Debbugs-Envelope-To: control X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) retitle 32209 [cuirass] Use SQLite in Multi-thread mode. From debbugs-submit-bounces@debbugs.gnu.org Thu Jul 19 08:45:41 2018 Received: (at control) by debbugs.gnu.org; 19 Jul 2018 12:45:41 +0000 Received: from localhost ([127.0.0.1]:47608 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fg8JR-0001cq-4z for submit@debbugs.gnu.org; Thu, 19 Jul 2018 08:45:41 -0400 Received: from mail.lassieur.org ([83.152.10.219]:49274) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fg8JQ-0001ch-4t for control@debbugs.gnu.org; Thu, 19 Jul 2018 08:45:40 -0400 Received: from newt (smtp.parrot.biz [62.23.167.188]) by mail.lassieur.org (OpenSMTPD) with ESMTPSA id f8dd9fee (TLSv1.2:ECDHE-RSA-CHACHA20-POLY1305:256:NO) for ; Thu, 19 Jul 2018 12:45:38 +0000 (UTC) Date: Thu, 19 Jul 2018 14:45:38 +0200 Message-Id: <87wotr5r7x.fsf@lassieur.org> To: control@debbugs.gnu.org From: clement@lassieur.org (=?utf-8?Q?Cl=C3=A9ment?= Lassieur) Subject: control message for bug #32209 MIME-version: 1.0 Content-type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Spam-Score: -0.0 (/) X-Debbugs-Envelope-To: control X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) retitle 32209 Cuirass: Use SQLite in Multi-thread mode. From debbugs-submit-bounces@debbugs.gnu.org Thu Jul 19 08:46:27 2018 Received: (at control) by debbugs.gnu.org; 19 Jul 2018 12:46:27 +0000 Received: from localhost ([127.0.0.1]:47614 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fg8KB-0001es-DK for submit@debbugs.gnu.org; Thu, 19 Jul 2018 08:46:27 -0400 Received: from mail.lassieur.org ([83.152.10.219]:49276) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fg8K8-0001ei-HE for control@debbugs.gnu.org; Thu, 19 Jul 2018 08:46:25 -0400 Received: from newt (smtp.parrot.biz [62.23.167.188]) by mail.lassieur.org (OpenSMTPD) with ESMTPSA id a43a3fee (TLSv1.2:ECDHE-RSA-CHACHA20-POLY1305:256:NO) for ; Thu, 19 Jul 2018 12:46:23 +0000 (UTC) Date: Thu, 19 Jul 2018 14:46:22 +0200 Message-Id: <87va9b5r6p.fsf@lassieur.org> To: control@debbugs.gnu.org From: clement@lassieur.org (=?utf-8?Q?Cl=C3=A9ment?= Lassieur) Subject: control message for bug #32209 MIME-version: 1.0 Content-type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Spam-Score: -0.0 (/) X-Debbugs-Envelope-To: control X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) retitle 32209 Cuirass: Use SQLite in Multi-thread mode From unknown Sat Jun 14 23:18:38 2025 X-Loop: help-debbugs@gnu.org Subject: [bug#32209] [PATCH] database: Use SQLite in Multi-thread mode. Resent-From: ludo@gnu.org (Ludovic =?UTF-8?Q?Court=C3=A8s?=) Original-Sender: "Debbugs-submit" Resent-CC: guix-patches@gnu.org Resent-Date: Fri, 20 Jul 2018 12:56:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 32209 X-GNU-PR-Package: guix-patches X-GNU-PR-Keywords: patch To: =?UTF-8?Q?Cl=C3=A9ment?= Lassieur Cc: 32209@debbugs.gnu.org Received: via spool by 32209-submit@debbugs.gnu.org id=B32209.15320913263791 (code B ref 32209); Fri, 20 Jul 2018 12:56:02 +0000 Received: (at 32209) by debbugs.gnu.org; 20 Jul 2018 12:55:26 +0000 Received: from localhost ([127.0.0.1]:48944 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fgUwQ-0000z5-4f for submit@debbugs.gnu.org; Fri, 20 Jul 2018 08:55:26 -0400 Received: from eggs.gnu.org ([208.118.235.92]:35406) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fgUwO-0000yt-FX for 32209@debbugs.gnu.org; Fri, 20 Jul 2018 08:55:24 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1fgUwG-0004om-A7 for 32209@debbugs.gnu.org; Fri, 20 Jul 2018 08:55:19 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00 autolearn=disabled version=3.3.2 Received: from fencepost.gnu.org ([2001:4830:134:3::e]:34160) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1fgUwG-0004oe-3D; Fri, 20 Jul 2018 08:55:16 -0400 Received: from [193.50.110.227] (port=52016 helo=ribbon) by fencepost.gnu.org with esmtpsa (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.82) (envelope-from ) id 1fgUwE-0000Xb-Uw; Fri, 20 Jul 2018 08:55:15 -0400 From: ludo@gnu.org (Ludovic =?UTF-8?Q?Court=C3=A8s?=) References: <20180719105457.32267-1-clement@lassieur.org> Date: Fri, 20 Jul 2018 14:55:12 +0200 In-Reply-To: <20180719105457.32267-1-clement@lassieur.org> ("=?UTF-8?Q?Cl=C3=A9ment?= Lassieur"'s message of "Thu, 19 Jul 2018 12:54:57 +0200") Message-ID: <87o9f2oymn.fsf@gnu.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] X-Received-From: 2001:4830:134:3::e X-Spam-Score: -5.0 (-----) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -6.0 (------) Hello! Cl=C3=A9ment Lassieur skribis: > This disables mutexing on database connection and prepared statement obje= cts, > thus making us responsible for serializing access to database connections= and > prepared statements. It may result in a performance improvement. > > * src/cuirass/database.scm (db-init, db-open): Pass the SQLITE_OPEN_NOMUT= EX > flag to SQLITE-OPEN. Could you copy (part of) the paragraph above as a comment above the =E2=80=98sqlite-open=E2=80=99 call in =E2=80=98db-open=E2=80=99? Then I guess you can go ahead and push! Thank you, Ludo=E2=80=99. From unknown Sat Jun 14 23:18:38 2025 MIME-Version: 1.0 X-Mailer: MIME-tools 5.505 (Entity 5.505) X-Loop: help-debbugs@gnu.org From: help-debbugs@gnu.org (GNU bug Tracking System) To: =?UTF-8?Q?Cl=C3=A9ment?= Lassieur Subject: bug#32209: closed (Re: [bug#32209] [PATCH] database: Use SQLite in Multi-thread mode.) Message-ID: References: <87in5a59db.fsf@lassieur.org> <20180719105457.32267-1-clement@lassieur.org> X-Gnu-PR-Message: they-closed 32209 X-Gnu-PR-Package: guix-patches X-Gnu-PR-Keywords: patch Reply-To: 32209@debbugs.gnu.org Date: Fri, 20 Jul 2018 13:24:02 +0000 Content-Type: multipart/mixed; boundary="----------=_1532093042-6668-1" This is a multi-part message in MIME format... ------------=_1532093042-6668-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" Your bug report #32209: Cuirass: Use SQLite in Multi-thread mode which was filed against the guix-patches package, has been closed. The explanation is attached below, along with your original report. If you require more details, please reply to 32209@debbugs.gnu.org. --=20 32209: http://debbugs.gnu.org/cgi/bugreport.cgi?bug=3D32209 GNU Bug Tracking System Contact help-debbugs@gnu.org with problems ------------=_1532093042-6668-1 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit Received: (at 32209-done) by debbugs.gnu.org; 20 Jul 2018 13:23:33 +0000 Received: from localhost ([127.0.0.1]:48962 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fgVNd-0001iq-4h for submit@debbugs.gnu.org; Fri, 20 Jul 2018 09:23:33 -0400 Received: from mail.lassieur.org ([83.152.10.219]:49934) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fgVNa-0001if-Ji for 32209-done@debbugs.gnu.org; Fri, 20 Jul 2018 09:23:31 -0400 Received: from newt (smtp.parrot.biz [62.23.167.188]) by mail.lassieur.org (OpenSMTPD) with ESMTPSA id d19e6cb8 (TLSv1.2:ECDHE-RSA-CHACHA20-POLY1305:256:NO); Fri, 20 Jul 2018 13:23:29 +0000 (UTC) References: <20180719105457.32267-1-clement@lassieur.org> <87o9f2oymn.fsf@gnu.org> User-agent: mu4e 1.0; emacs 26.1 From: =?utf-8?Q?Cl=C3=A9ment?= Lassieur To: Ludovic =?utf-8?Q?Court=C3=A8s?= Subject: Re: [bug#32209] [PATCH] database: Use SQLite in Multi-thread mode. In-reply-to: <87o9f2oymn.fsf@gnu.org> Date: Fri, 20 Jul 2018 15:23:28 +0200 Message-ID: <87in5a59db.fsf@lassieur.org> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Spam-Score: -0.0 (/) X-Debbugs-Envelope-To: 32209-done Cc: 32209-done@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) Ludovic Court=C3=A8s writes: > Hello! > > Cl=C3=A9ment Lassieur skribis: > >> This disables mutexing on database connection and prepared statement obj= ects, >> thus making us responsible for serializing access to database connection= s and >> prepared statements. It may result in a performance improvement. >> >> * src/cuirass/database.scm (db-init, db-open): Pass the SQLITE_OPEN_NOMU= TEX >> flag to SQLITE-OPEN. > > Could you copy (part of) the paragraph above as a comment above the > =E2=80=98sqlite-open=E2=80=99 call in =E2=80=98db-open=E2=80=99? Done, and pushed. Thanks! Cl=C3=A9ment ------------=_1532093042-6668-1 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit Received: (at submit) by debbugs.gnu.org; 19 Jul 2018 10:55:37 +0000 Received: from localhost ([127.0.0.1]:47548 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fg6au-0003Q4-Pd for submit@debbugs.gnu.org; Thu, 19 Jul 2018 06:55:37 -0400 Received: from eggs.gnu.org ([208.118.235.92]:49753) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fg6au-0003Pt-0i for submit@debbugs.gnu.org; Thu, 19 Jul 2018 06:55:36 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1fg6an-0005x0-4v for submit@debbugs.gnu.org; Thu, 19 Jul 2018 06:55:30 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=0.8 required=5.0 tests=BAYES_50 autolearn=disabled version=3.3.2 Received: from lists.gnu.org ([2001:4830:134:3::11]:37374) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1fg6am-0005wo-TD for submit@debbugs.gnu.org; Thu, 19 Jul 2018 06:55:29 -0400 Received: from eggs.gnu.org ([2001:4830:134:3::10]:40719) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1fg6ak-0007sH-O5 for guix-patches@gnu.org; Thu, 19 Jul 2018 06:55:28 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1fg6af-0005sp-Tn for guix-patches@gnu.org; Thu, 19 Jul 2018 06:55:26 -0400 Received: from mail.lassieur.org ([83.152.10.219]:59534) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1fg6af-0005nz-J1 for guix-patches@gnu.org; Thu, 19 Jul 2018 06:55:21 -0400 Received: from newt.Parrot.Biz (smtp.parrot.biz [62.23.167.188]) by mail.lassieur.org (OpenSMTPD) with ESMTPSA id df973103 (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256:NO) for ; Thu, 19 Jul 2018 10:55:17 +0000 (UTC) From: =?UTF-8?q?Cl=C3=A9ment=20Lassieur?= To: guix-patches@gnu.org Subject: [PATCH] database: Use SQLite in Multi-thread mode. Date: Thu, 19 Jul 2018 12:54:57 +0200 Message-Id: <20180719105457.32267-1-clement@lassieur.org> X-Mailer: git-send-email 2.18.0 X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] [fuzzy] X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x X-Received-From: 2001:4830:134:3::11 X-Spam-Score: -4.1 (----) X-Debbugs-Envelope-To: submit X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -5.1 (-----) This disables mutexing on database connection and prepared statement objects, thus making us responsible for serializing access to database connections and prepared statements. It may result in a performance improvement. * src/cuirass/database.scm (db-init, db-open): Pass the SQLITE_OPEN_NOMUTEX flag to SQLITE-OPEN. --- src/cuirass/database.scm | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) diff --git a/src/cuirass/database.scm b/src/cuirass/database.scm index a84d0fa..6bf3bc4 100644 --- a/src/cuirass/database.scm +++ b/src/cuirass/database.scm @@ -195,7 +195,8 @@ database object." (format (current-error-port) "Removing leftover database ~a~%" db-name) (delete-file db-name)) (let ((db (sqlite-open db-name (logior SQLITE_OPEN_CREATE - SQLITE_OPEN_READWRITE)))) + SQLITE_OPEN_READWRITE + SQLITE_OPEN_NOMUTEX)))) (db-load db schema) (db-set-schema-version db (latest-db-schema-version)) db)) @@ -222,7 +223,9 @@ database object." ;; avoid SQLITE_LOCKED errors when we have several readers: ;; . (set-db-options (if (file-exists? db) - (db-upgrade (sqlite-open db SQLITE_OPEN_READWRITE)) + (db-upgrade + (sqlite-open db (logior SQLITE_OPEN_READWRITE + SQLITE_OPEN_NOMUTEX))) (db-init db)))) (define (db-close db) -- 2.18.0 ------------=_1532093042-6668-1--