[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Monotone-devel] Re: SQLite3 port available
From: |
Christof Petig |
Subject: |
[Monotone-devel] Re: SQLite3 port available |
Date: |
Thu, 18 Nov 2004 23:50:36 +0100 |
User-agent: |
Mozilla/5.0 (X11; U; Linux ppc; de-AT; rv:1.7.3) Gecko/20041007 Debian/1.7.3-5 |
Christof Petig schrieb:
Possible future optimizations include using BLOBs to store sha1 values
and patches (further reducing the size) and using query parameters
(speeding it up).
[sharing my mental notes]
The following columns are candidates for BLOBs:
file_deltas.id .base .delta (gz)
files.id .data (gz)
manifest_certs.hash .id .value .signature
manifest_deltas.id .base .delta (gz)
manifests.id .data (gz)
merkle_nodes.body
private_keys.hash .keydata
public_keys.hash .keydata
revision_ancestry.parent .child
revision_certs.hash .id .value .signature
revisions.id .data (gz)
[ some are hex encoded: id base hash ]
BLOBing *_certs would speed up most operations since trusted() is called
on its columns.
BLOBing id, base, hash; delta, data would yield most space savings (50%/25%)
Perhaps a modification (unfolding) of the views might speed things up
(perhaps the expensive function trusted() is also called on rows which
get filtered out lateron).
signature.asc
Description: OpenPGP digital signature