[Monotone-devel] Re: SQLite3 port available

[Christof Petig]

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