From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <sourceware-bugzilla@sourceware.org>
Received: by sourceware.org (Postfix, from userid 48)
	id 8D4013858C74; Fri, 21 Apr 2023 18:00:00 +0000 (GMT)
DKIM-Filter: OpenDKIM Filter v2.11.0 sourceware.org 8D4013858C74
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sourceware.org;
	s=default; t=1682100000;
	bh=bjLYZncEzYXx0prjyHAiK1E11v9XpCutT0hPudupuwU=;
	h=From:To:Subject:Date:From;
	b=xoSO7jwdVrHe57FkxiI8yiuSlA5RgD1GAqELATK6sVpjPweYUzoNkzpWv+eggG4QC
	 FFoKY+CcBay7GBB+RzdWAbVuVc+teyhb5hIWyxroLi3v9glAibxBT6bNrQDKMJ9DwR
	 R1A8lgtCMkIRsHLzK+tHwuFNUNRB1D2tptKiSXCw=
From: "fche at redhat dot com" <sourceware-bugzilla@sourceware.org>
To: elfutils-devel@sourceware.org
Subject: [Bug debuginfod/30378] New: need better compression of the _files
 table
Date: Fri, 21 Apr 2023 18:00:00 +0000
X-Bugzilla-Reason: CC
X-Bugzilla-Type: new
X-Bugzilla-Watch-Reason: None
X-Bugzilla-Product: elfutils
X-Bugzilla-Component: debuginfod
X-Bugzilla-Version: unspecified
X-Bugzilla-Keywords: 
X-Bugzilla-Severity: normal
X-Bugzilla-Who: fche at redhat dot com
X-Bugzilla-Status: NEW
X-Bugzilla-Resolution: 
X-Bugzilla-Priority: P2
X-Bugzilla-Assigned-To: unassigned at sourceware dot org
X-Bugzilla-Target-Milestone: ---
X-Bugzilla-Flags: 
X-Bugzilla-Changed-Fields: bug_id short_desc product version bug_status
 bug_severity priority component assigned_to reporter cc target_milestone
Message-ID: <bug-30378-10460@http.sourceware.org/bugzilla/>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Bugzilla-URL: http://sourceware.org/bugzilla/
Auto-Submitted: auto-generated
MIME-Version: 1.0
List-Id: <elfutils-devel.sourceware.org>

https://sourceware.org/bugzilla/show_bug.cgi?id=3D30378

            Bug ID: 30378
           Summary: need better compression of the _files table
           Product: elfutils
           Version: unspecified
            Status: NEW
          Severity: normal
          Priority: P2
         Component: debuginfod
          Assignee: unassigned at sourceware dot org
          Reporter: fche at redhat dot com
                CC: elfutils-devel at sourceware dot org
  Target Milestone: ---

Enumerating each file name (whether an archive name or a file within an arc=
hive
or a source file name referenced from a dwarf file) inside the _files table
means storing many near-duplicate strings in that table.  Considering split=
ting
it up into basename / dirname subtables, with _files containing their id-pa=
ir
only rather than a potentially long string.  Expecting drastic reduction in
sqlite data size.

--=20
You are receiving this mail because:
You are on the CC list for the bug.=