From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Richard Stallman Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 Date: Wed, 15 Dec 2021 23:38:47 -0500 Message-ID: References: <87tufmjyai.fsf@gnus.org> <87lf0nr2b4.fsf@gnus.org> Reply-To: rms@gnu.org Content-Type: text/plain; charset=Utf-8 Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="17969"; mail-complaints-to="usenet@ciao.gmane.io" Cc: emacs-devel@gnu.org To: Lars Ingebrigtsen Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Thu Dec 16 05:39:41 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 1mxiYO-0004Tj-L0 for ged-emacs-devel@m.gmane-mx.org; Thu, 16 Dec 2021 05:39:40 +0100 Original-Received: from localhost ([::1]:51588 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mxiYN-0005wS-J1 for ged-emacs-devel@m.gmane-mx.org; Wed, 15 Dec 2021 23:39:39 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:46666) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mxiXX-0004xc-Hv for emacs-devel@gnu.org; Wed, 15 Dec 2021 23:38:47 -0500 Original-Received: from [2001:470:142:3::e] (port=48182 helo=fencepost.gnu.org) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mxiXX-00052l-6h; Wed, 15 Dec 2021 23:38:47 -0500 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnu.org; s=fencepost-gnu-org; h=Date:References:Subject:In-Reply-To:To:From: mime-version; bh=NpRR1yV+QUOx1u06XrqyeTwDSCt/DjbYJbWORjEoJHg=; b=lIYleZcJxVzZ HlXbh+MDmKVfOM/hs4teBbvDZlAjBNs48qLLRdGvnW9KQJ12PVeVULdUauhnvz4yqyIQuYi+4E54Y drfJgsHqYgNTcOQPIsRm2baQP3ynKBQA4rH/J0ITPqpB5PQfpXGQuiVKpIi6gUi/jaroav/X0XZ7s CKzbEgED3zu/lurmVJRfUcUO7svQ04Qr1F0KVP5bGBxB79LmU7ZcAmqzFHSsCWKVxke+2fUgu8LcC vPU9QhzZpqX9FmQWk2aUSr31tWpjS1N00F+ypnEPMn65rqlpZ8n0tHKCc/b4H1FYYAI6BB45tdKIi dCfefOa9tiQA+7vaEN797g==; Original-Received: from rms by fencepost.gnu.org with local (Exim 4.90_1) (envelope-from ) id 1mxiXX-0002UV-B8; Wed, 15 Dec 2021 23:38:47 -0500 In-Reply-To: <87lf0nr2b4.fsf@gnus.org> (message from Lars Ingebrigtsen on Tue, 14 Dec 2021 09:57:51 +0100) 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:282084 Archived-At: [[[ To any NSA and FBI agents reading my email: please consider ]]] [[[ whether defending the US Constitution against all enemies, ]]] [[[ foreign or domestic, requires you to follow Snowden's example. ]]] > 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). Is that terribly wasteful of space? I have a feeling it must be. But I don't know how ext file systems organize disk space, so I could be mistaken. Does anyone know? -- Dr Richard Stallman (https://stallman.org) Chief GNUisance of the GNU Project (https://gnu.org) Founder, Free Software Foundation (https://fsf.org) Internet Hall-of-Famer (https://internethalloffame.org)