Hi, all,

Here's a silly fossil trick you'll certainly never need to do...

observe the creation of delta- vs baseline manifests in the repository by
looking at historical checkin data... the larger (>10kb) checkins are
baselines. The others are deltas generated from (normally) the next-oldest
baseline.

sqlite> select substr(b.uuid,0,12),
  datetime(ev.mtime),
  b.size
  from blob b
  join event ev on ev.objid=b.rid
  AND ev.type='ci'
  order by ev.mtime DESC limit 50
;
substr(b.uuid,0,12)|datetime(ev.mtime)|size
e3e78d17862|2014-03-17 19:14:59|1824
811508a6020|2014-03-17 19:14:14|1765
8625a31eff7|2014-03-17 15:27:49|1756
e4bf163a5f0|2014-03-17 14:40:42|1412
47401e17639|2014-03-16 17:32:05|1420
adb83cc6102|2014-03-16 17:30:09|1297
c0b8ce3c1d7|2014-03-16 17:28:38|1290
2f280271d5d|2014-03-16 17:26:53|1219
be2b468e4e7|2014-03-16 17:08:57|1162
b96ea63caf4|2014-03-16 13:41:15|1147
752aad3eb7b|2014-03-16 13:03:37|1249
7943808461a|2014-03-16 11:25:47|1309
c8c97fd8fe1|2014-03-15 17:36:14|986
439762f2053|2014-03-15 17:28:13|282
9664c64ba37|2014-03-15 15:39:03|14270 <<-- baseline
3e6f247357b|2014-03-15 15:02:48|1688
f17950f7756|2014-03-15 15:02:30|1685
2cbcbf62a31|2014-03-15 15:01:43|1681
a92bffdddff|2014-03-15 13:35:58|1646
4be2703578b|2014-03-15 09:48:05|1590
a5bda1ae61d|2014-03-15 09:33:25|1624
668349fdb0c|2014-03-14 20:50:40|1608
968a993c60e|2014-03-14 14:53:40|1247
df8d4f2bb01|2014-03-14 14:51:20|866
c71f986d359|2014-03-14 14:25:30|828
853ec1f6503|2014-03-14 12:10:26|14065 <<-- baseline
5900ce9dee0|2014-03-14 12:01:23|1709
a75ca1c3231|2014-03-14 11:57:31|1706
c3660f5241c|2014-03-14 11:52:47|1975
7e8d0ecfe20|2014-03-14 11:10:05|1652
ab56d2d9a07|2014-03-14 11:04:43|1723
1dff0493d2d|2014-03-14 10:47:24|1541
286b8aea1a4|2014-03-14 00:07:25|1454
447f497409a|2014-03-13 23:48:38|1453
49961898ba4|2014-03-13 23:18:01|1406
ab6c9982c16|2014-03-13 21:50:54|1366
0096d28c969|2014-03-13 20:59:29|1370
9a07a781592|2014-03-13 20:53:34|1370
e3241eae556|2014-03-13 20:04:08|1290
4740bce980a|2014-03-13 19:42:13|1218
67c1885126c|2014-03-13 19:40:48|1215
2bba3a248f3|2014-03-13 18:20:34|1100
71f8421ed7d|2014-03-13 17:44:26|889
bc0e0001996|2014-03-13 15:39:09|974
2de81ae7b6a|2014-03-13 14:39:40|13764 <<-- baseline
f994fec9c56|2014-03-13 12:00:02|1814
7e5ca27c8c9|2014-03-13 11:36:49|1648
7e759995ce1|2014-03-13 11:06:35|1553
375f435549d|2014-03-13 09:42:25|1254
c10bc4977a5|2014-03-13 09:41:33|1196


fossil uses an algorithm (which libfossil steals) to determine whether a
given delta manifest is "too big to be worth the effort," and when it comes
across that case it generates a baseline manifest instead. Thus every so
often a new baseline appears.

This same query on the core Fossil repo looks very different because it has
no delta manifests - each checkin is currently about 44kb (uncompressed).

So why is this all interesting data? Because i'm touching those particular
bits in libfossil tonight and like to see that they're working :). Outside
of that context, it's probably not all that interesting.

-- 
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
_______________________________________________
fossil-users mailing list
[email protected]
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users

Reply via email to