From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: =?utf-8?Q?=C3=93scar_Fuentes?= Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 Date: Tue, 14 Dec 2021 10:57:07 +0100 Message-ID: <87ilvr5x1o.fsf@telefonica.net> References: <87tufmjyai.fsf@gnus.org> <87lf0nr2b4.fsf@gnus.org> Mime-Version: 1.0 Content-Type: text/plain Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="6520"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) To: emacs-devel@gnu.org Cancel-Lock: sha1:os4vhEn1489eIvGXjM3rE60oGpM= Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Tue Dec 14 10:58:02 2021 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 1mx4ZN-0001M0-Mm for ged-emacs-devel@m.gmane-mx.org; Tue, 14 Dec 2021 10:58:01 +0100 Original-Received: from localhost ([::1]:50488 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mx4ZL-0002Xg-Kh for ged-emacs-devel@m.gmane-mx.org; Tue, 14 Dec 2021 04:57:59 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:35716) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mx4Yh-0001se-56 for emacs-devel@gnu.org; Tue, 14 Dec 2021 04:57:20 -0500 Original-Received: from ciao.gmane.io ([116.202.254.214]:42828) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mx4Yf-00074b-4E for emacs-devel@gnu.org; Tue, 14 Dec 2021 04:57:18 -0500 Original-Received: from list by ciao.gmane.io with local (Exim 4.92) (envelope-from ) id 1mx4Yc-0000OI-Ja for emacs-devel@gnu.org; Tue, 14 Dec 2021 10:57:14 +0100 X-Injected-Via-Gmane: http://gmane.org/ Received-SPF: pass client-ip=116.202.254.214; envelope-from=ged-emacs-devel@m.gmane-mx.org; helo=ciao.gmane.io X-Spam_score_int: -16 X-Spam_score: -1.7 X-Spam_bar: - X-Spam_report: (-1.7 / 5.0 requ) BAYES_00=-1.9, HEADER_FROM_DIFFERENT_DOMAINS=0.248, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=no 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:281884 Archived-At: Lars Ingebrigtsen writes: > As for the sqlite part of this: My initial benchmarking of this was > wrong. I thought sqlite3 was going to be a real advantage for this > thing, since I'd benchmarked excellent performance (more than 50K > updates per second, for instance). But that's only when not committing > after every transaction, which we want to do here, really. > > But it turns out that sqlite3 is actually slower Surprise! :-) > 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'. I'm pretty sure SQlite is providing stronger persistence guarantees than the file system. For persisting data to disk, you either have a fast db or a robust db. Not both. OTOH, the "one file per value" part above sounds somewhat scary :-)