From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Jean Louis Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 Date: Mon, 14 Feb 2022 18:15:39 +0300 Message-ID: References: <87tufmjyai.fsf@gnus.org> <87lf0nr2b4.fsf@gnus.org> <87czlzjfhs.fsf@logand.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="29234"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Mutt/2.2.0 (2022-02-12) Cc: Lars Ingebrigtsen , emacs-devel@gnu.org To: Tomas Hlavaty Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Mon Feb 14 16:50:49 2022 Return-path: Envelope-to: ged-emacs-devel@m.gmane-mx.org Original-Received: from lists.gnu.org ([209.51.188.17]) by ciao.gmane.io with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nJdcm-0007Pe-AT for ged-emacs-devel@m.gmane-mx.org; Mon, 14 Feb 2022 16:50:48 +0100 Original-Received: from localhost ([::1]:59424 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nJdck-0005Ur-8W for ged-emacs-devel@m.gmane-mx.org; Mon, 14 Feb 2022 10:50:46 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:41144) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nJd8f-0004mY-7c for emacs-devel@gnu.org; Mon, 14 Feb 2022 10:19:41 -0500 Original-Received: from stw1.rcdrun.com ([217.170.207.13]:53649) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nJd8d-0002YA-Dh for emacs-devel@gnu.org; Mon, 14 Feb 2022 10:19:40 -0500 Original-Received: from localhost ([::ffff:41.75.189.127]) (AUTH: PLAIN admin, TLS: TLS1.3,256bits,ECDHE_RSA_AES_256_GCM_SHA384) by stw1.rcdrun.com with ESMTPSA id 0000000000067F6D.00000000620A7307.00007D58; Mon, 14 Feb 2022 08:19:35 -0700 Mail-Followup-To: Tomas Hlavaty , Lars Ingebrigtsen , emacs-devel@gnu.org Content-Disposition: inline In-Reply-To: <87czlzjfhs.fsf@logand.com> Received-SPF: pass client-ip=217.170.207.13; envelope-from=bugs@gnu.support; helo=stw1.rcdrun.com X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-devel@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "Emacs development discussions." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Original-Sender: "Emacs-devel" Xref: news.gmane.io gmane.emacs.devel:286282 Archived-At: * Tomas Hlavaty [2021-12-14 19:53]: > On Tue 14 Dec 2021 at 09:57, Lars Ingebrigtsen wrote: > > But it turns out that sqlite3 is actually slower for this particular use > > case than just writing the data to a file (i.e., using the file system > > as the database; one file per value). So multisession.el now offers two > > backends (`files' and `sqlite'), and defaults to `files'. > > So it turned out that sqlite is actually slower > but Emacs is stuck with sqlite dependency anyway? > Is my understanding correct? Reference for more research: 35% Faster Than The Filesystem https://www.sqlite.org/fasterthanfs.html -- Jean Take action in Free Software Foundation campaigns: https://www.fsf.org/campaigns In support of Richard M. Stallman https://stallmansupport.org/