C web:\sthe\sfiles\spage\swas\sunusably\sslow;\sfix\sthe\squery,\smemoise,\scap\sthe\slist\n\nThree\sseparate\sfaults,\sworst\sfirst.\n\nBranches()\sused\sa\scorrelated\ssubquery\s—\sone\sfull\sscan\sof\scheckin\sper\nrow.\sOn\stcl\s(42,074\scheck-ins,\s1,855\sbranches)\sthat\stook\s434\sSECONDS,\nwhich\sis\swhat\smade\sthe\spage\slook\shung\srather\sthan\sslow.\sOne\sgrouped\sscan\nwith\sSQLite's\sbare-column-with-max\srule,\splus\san\sindex\son\n(branch,\sdate):\s0.042s.\n\n'ls\s--long'\scosts\s~4ms\sper\sfile\sbecause\sit\sreads\seach\sblob\sfor\ssize\sand\nthe\sbinary\sflag,\sso\stcl's\s2,198-path\stip\stook\s8.5s.\sFossil\snever\spays\nthis\s—\sbrowse.c\sbuilds\sa\sdirectory\slisting\sfrom\sits\sown\sindexed\stables\nand\sshows\sno\ssize\sat\sall\s—\sbut\squarry\sreads\sthrough\sthe\sCLI\sby\sdesign,\nso\sthe\sanswer\sis\sto\scompute\sonce:\sa\scheck-in's\sfile\sset\sis\sIMMUTABLE,\sso\nlistings\sare\smemoised\sper\sversion,\sthe\stip\sis\swarmed\safter\seach\singest,\nand\sthe\stree\sop\sresolves\s'trunk'\sto\sits\shash\sso\sthe\spage\sasks\sfor\sthe\nkey\sthat\swas\swarmed.\n\nOnly\sa\shash\smay\sbe\scached.\sCaching\s'trunk'\swould\sserve\sa\sstale\stree\nforever\safter\sthe\snext\scommit\s—\sa\scorrectness\sbug\sdressed\sas\sa\nperformance\sfix\s—\sso\sthe\smemo\srefuses\sanything\sthat\scan\smove,\swith\sa\ntest\spinning\sit.\n\nThe\sbranch\sselector\srendered\severy\sbranch:\s1,855\s<option>\selements,\s90%\nof\sa\s239KB\spage,\sand\sunusable\sas\sa\scontrol.\sNow\sthe\s25\smost\srecently\nactive,\splus\sthe\sbranch\sbeing\sviewed\seven\swhen\sit\sis\solder.\n\ntcl's\srepo\shome:\s8.5s\s->\s0.38s,\s239KB\s->\s29KB.\ssqlite:\s5.0s\s->\s0.32s.
D 2026-08-17T15:52:12.934
F .agent-config/trace/3f875275-22da-47ce-9029-4d8fe8533afc.jsonl 8d09a15db695597c50931036b65ca941160ecb29dc54a787c43a469e2bad1efe
F .claude/scheduled_tasks.lock 4f16ccd1bdcb82c6a511d59819332b0806bb00951237dd68a0d64368958c84c9
F Makefile 27950a92fe0d5bc88bbbfcc2194ea96cc2cb3f6b7f3314db043ca1152e96eb87
F README.md ee56e71e8b5b6ac04964976f9f05406ea43d3be5d6302122a0349f141458dd2b
F cmd/quarry/main.go eaa1822322603f924b2abca8014ad08d8b6f4bb549e8768c367cb08fca73fac7
F cmd/quarry/topic_test.go 2271bccd2a41501287b9bc758e5520a96023b9b3824eb1d882d5a893db08490e
F docs/api.md 695e3fad8c7be83d229b6fcd2c32b32eacdef18c0f64d22b6e9378808e065302
F docs/rfcs/0001-quarry-forge.md b882642a35a05b449af6b7164149e5f1b9f5cccaf7ec756c60a8951ea71a895c
F docs/rfcs/0002-forgejo-salvage.md 610f8d4b4d580b5df133f35e33946a4293f19fad6c25dac64791c6ed2ba3af07
F docs/rfcs/0003-implementation-plan.md 5ffa5c2d3d7bf31ea5f1813721bc6533f468506864679ac9a31717ebd24e82e5
F fixtures/README.md 3e3c12bbbf5cd024d3e0c9cde121a495f81c4f90297ec7e676be6334658231eb
F fixtures/build-real.sh 6223826ad836b49c90c896e442fcacac716489885e98bdf0a5958a88a897a11e x
F fixtures/build-synthetic.sh ad3ed7c42bc960a0b317187704a8c39d79e4586dc5ce99e71c003e43e80314f1 x
F g1.json ba4e504904768f2d8569659f8c7057016df1d8694c1be3dbf350ca759c5d35bc
F g2.html c416f95e362dd5f65bb6353ce7df0c54070f62eee92edfcbdac498151d244c37
F g3.json fec7f152f2296027ab4afa7714601ff9425793643a5b53dce1092dfbce2aabcd
F go.mod e997d75dcef01c0c61e6c58b3d823199fa92ecd4850fd0918ae879216c328879
F go.sum 720add7ff37d7ec29b8ff9ea0804774dd8426960d4a68c0e8097268cde6efa0c
F internal/api/docs_test.go 0052df1f7bf6c5d994996e380434d6043d07aac33753f6752cea3f58dc53aae8
F internal/api/register.go d6d0d911388e369252b90f6f0cb56b9e361eca015759da7c68a5e929b24f7292
F internal/api/register_test.go dfab21bfb627c76c455b16c7c2c81700a09fc5803ecc2c3ca9e47e05e55f9758
F internal/api/router.go 5f7e3562172ba14f29bcf54f89ae653b68c448c78519988c16408b0ea2530009
F internal/api/router_test.go f546b871500ecad53f526c50c35fd47514431300de87539e3c3075a74a16d5fc
F internal/arch/arch_test.go d15796b585214a57107e29be2687fcd09cccf233551f1b56458a79d38ecb29f8
F internal/arch/provenance_test.go 159fb708ff07fed8d2c7b25f8b75dffa33e45e07848741ec9c3db569cffdf9d9
F internal/artifact/artifact.go 418ae72f4929b3695aecd1f0695ca54be163e18a51a27bc5f0378fb6c481a39f
F internal/artifact/artifact_test.go 5877c8d2bd5ff3075378da7abe78097b92607a742f40c50159119aad01dfe556
F internal/artifact/cards.go 0cbc0f2a1cc33dedee2bea5db929acef70f2b445a736b41ae366ecca8202ea0e
F internal/artifact/testdata/0e741ff903ec2699c0bb6c989d398feaa0d0b29e3e260519ade0dac4292886c9 1ee74974343a8ea6a8bdcf4c9b58aeb395268fe28018e5c299285f9bcd5fca40
F internal/artifact/testdata/1c8fe43423f7926d13e025f35e100f7bf478fe04b381393eb55a22dc4ca2781f 0e8a46734f5ba52445ee8839a9b4ed2c921730e1a53145d712ec50a3cd9cd9f0
F internal/artifact/testdata/22aba910a511ec9a4b21f6887fd2bf35a3cc043b1b7f07ff730beb730e1c63aa b11ee3b756cac012a7f219aadaa9be2cdca08c219029f77cececf8c9c8520f9b
F internal/artifact/testdata/2d964281d9a46df31b7864f191dc20b3d8a0f15ca66741f3121c9412d6386539 38a50e80c13f6e2f19fb66abe5e1d974067eaec1513c07952e6e89f9d0fa9219
F internal/artifact/testdata/67ce7cb478361333587f5e96df3ce8de0e1c731b919500890a82bd61d45ea116 a0b1f851ddd51caeec85f01d3e441156ecdea1c1313f9021ef8604603365cefe
F internal/artifact/testdata/6fad022ec04b5ff757c03d2e6e55b25ca724b181f2a04181afc043791c42fb69 2143301b7bb5554413f6f0281c50fe76a1d0f65ae11bf76a26e7b4ac336245e0
F internal/artifact/testdata/75d862c5cabfab03b3d4b879ddd743c0f1fc282ab0b68bb44d414b1ce1465098 73d49f9c8e8abaa6da3fef95420afe7c098de0ff3387243cd73be220215bd4ef
F internal/artifact/testdata/7a09d0af4bed8ff86e5ac47a65786a12720c44a3ffd06cf36e45119f07e9a17e 8d1093187cd2293afb87e21b911c1918895c6b8d66edfb1c50d2584266cf0da8
F internal/artifact/testdata/7d3db57aec827893080e91f89d77278d72a1cadfd857b2b58fcc84be94addb59 fd74975d897a97515d53009bd316c8cc0fb2a7efe6019e7b252e70342fe43380
F internal/artifact/testdata/842ff48130d9076d59c96ff4205160f1c11d2f08d13d6bb012abf3ebc1d34728 d5463a912ab850fc06c667a0116f92b998f7720a57ad0721d7bf38d7c1fb82c8
F internal/artifact/testdata/857f5113b4a56d98f67ca9824cd126785443c84bf380d2e6c50535000526a23d 5f5826ed1d770b70ad0d17a77fff0937000bf5e9c8bb318e8b43ac954909b3a4
F internal/artifact/testdata/92ad090193c1dcae97fc91e2961c366963c5310da276760507ed098830b36527 0091840ae580e8d1f57cfd7165e3a3c419f0c042c9f4cfc27fe822031bbee41d
F internal/artifact/testdata/9a9719984127d081c38b60aeb3034789b67b517a11cf0e102f3f1161f2ccd2a8 0d8dee882aa8548d8390c4a1a191014d1851a1f4504d89ed6f8b476ae7e9d6a7
F internal/artifact/testdata/a14f59c3482ca0995ede44b5852663aa082510fbc367de2cf824e3d6dec87b21 89b9df46eb2ebc140fea4be7a4d63904a545c76357521680714948d51b3d5aa4
F internal/artifact/testdata/a20a12edd47bf1f6356e6fe4edfc03f256e8f5f3210fda8bb87ed32bda41481c e3e0a999508bb38e3b69b8cf71804f05eee6c6f2443b5115270122033a76d661
F internal/artifact/testdata/d7b481c91439081d7dc657cdc39501be119722a01b62f6bbe2301242ea7771d5 bae46b266a56de194b71c025c06e147df65996c4c825e552a82b13784ef9f3c5
F internal/artifact/testdata/ee71cf2323b8938af58e70e869ca0337fc8fc6df0af15382e8c53e7e783841ba 68f344158c2831de0bfa9ae3796a9e934f2e2fb49a076432e11ba312c31c3b4c
F internal/chat/chat.go 0c15ae46c4f70da50d8f3f1d9f7d8989810da1ac4402a4f71ce821c3f392dc9a
F internal/chat/chat_test.go 067965cd562f1aec887f262900a691f6de4ac6aa690ffd3f9785c01e8855d3b6
F internal/ci/ci.go aba94b088eae77ab3711c0858f023b1f5cc728600b7573fc129672367cb4655d
F internal/ci/ci_test.go fb10ec333da8e1e0ac385fe3f63319fdb5f2d9346fcf32b0dd6c6724a452f005
F internal/ci/trigger.go 02f0b450838bcbef08f250dbbc6270cf7b136289ca9e5c808fc9c6729775462a
F internal/events/events.go 0e859f830123060c4bd67b179d5a5d3d3b4a62c2816a0f9e2cfee0cbb973eace
F internal/events/events_test.go c6dd0474367db79984c9e9fe90059a367d0b4614700f9096418cd56ebb9027da
F internal/events/external_test.go 359ebae54edd9c207125e35548f7668612db288d60304d9b7521d3e4c0f310cc
F internal/harness/harness_test.go 961c4f28da8adaf4b69f8453eb662aad5292856df57cc16e7754ca67d2494332
F internal/harness/write_test.go 4051215ef8d536c6a36e6ca5f57d6bb30c69c3b1d73854209c9e42167f6ae160
F internal/highlight/highlight.go 7226c479b989360b6b0df5f916e38cd4a93738008b2e7d6a02cb405177dec9db
F internal/highlight/highlight_test.go 7e09b549dd597b32af1f932f25ce2957a3a4fa5b0fa7d24b0d8d789355d6e6dc
F internal/index/attachment_test.go c0687a74b80b7975b66cf108228bd13949e472760d70494f6160a26fff2d1827
F internal/index/index.go 4c7b236ba298d032f08b1d4cd58468b44b93ac33cd719ccd38da85ccd697fad0
F internal/index/parity_test.go b8d137240f19b50df119297b44b514d84d43095cfb351000f512ef667b0ac444
F internal/index/tktcheck_test.go f273e97bcbc2d819c0b01e92000a4dc8b87c8a2e593434a9f14c95ac29ed8ddf
F internal/ingest/ingest.go bc1d18f8f09f7e4397516a0a6579f1167a40c038bd5a7bf064637d7b5e2aa873
F internal/ingest/ingest_test.go ee45596db41368601d86497b1b945e15c651fb08c4968e2cef788e7fee09046c
F internal/lease/lease.go 233d73850c97f89d6375c76f2d731d4d48e8bb69cd79b77d7eb11f5c4ea2bef1
F internal/lease/lease_test.go 32f256f621db920aa6470b2c737447b38dfb404d1f3aa6df82f129cf4e37d25c
F internal/markup/fossilwiki.go 08d944a20eed77ec4e1331129d5ff5d507f8baef786ca0bd5b5af3a4a7248492
F internal/markup/fossilwiki_test.go d3a9d4b8dd9616b9305e7b9cf2e39a3278283acc1c40adcd6e411416f9279b6c
F internal/markup/markup.go d6b1b8289dd5d333a915305e8692849bb12d01709d15497518318616f6998307
F internal/markup/markup_test.go f77821f0de5c21f1ada30a7b02aa66775d54ca04138578e875d6f652e5e0732e
F internal/markup/pikchr.go 727389d23db40bc39a5fb82d38daefcb92a86b04d7092d11f31d3166d94ec98a
F internal/markup/pikchr_test.go 1286b504a64124283487a754f261a866e5b2f2c524e5811e73a3090dd186e4b3
F internal/markup/resolver.go 2b03aed79336d7becba88fe3f7ac0efa1b32fe42d0be79d564fe16b4297bacee
F internal/notify/inbox_test.go e0597232e5993d65c09d1f72513feecdf94f4ae57647194085c4915aec0a9e8a
F internal/notify/notify.go d0f20d69f845950c0cebf8a6dfa4ae19410f0dfe83db46bfcf6d66beb70b7459
F internal/notify/notify_test.go 8ea9d98c79346f291b857cbc469027b32dbdc53d88b74193417d6820d19a6248
F internal/oltp/account.go 80607038ecd296ba97bb4db7a61ae53c269f516841f9387028d4d17e9b78eab9
F internal/oltp/account_test.go e7c037a3a603f5afa0037c9a9dc1374d3c8a160688db6bcb7d21d498610e4a2a
F internal/oltp/ci.go 191650af9ba314215b4c73481f78952c6d746f604debb8abc1c29f1bc839aba8
F internal/oltp/oltp.go 870cf9518a73147ccf2c9d714d250d354249337b7700a7a67a1c4d4d6ab09e6e
F internal/oltp/password.go 0f8257af851a52d147a8681b46f4d15ff4bd65d558fd8b2055fb2a5a2e11be07
F internal/oltp/session.go 7827bbc0f8096ae1c4b2dd856bbc8342dbf58040406dc880c2b6df93099096d8
F internal/oltp/webhook.go c574963bc90596605ffc691aa5009c80354bb7c8cf505f7d9fc39aee1a2b74df
F internal/ops/codec.go 49dcf9b3d2fb45b552604985493cbda0ab898e73948dd85996524fd395670dc4
F internal/ops/codec_test.go 7b9776ac4a5f11c1f5fa66683282e996dce4dd4dac534dbd5a8b36627482129d
F internal/ops/docs.go cffc8f3b7ebeeb89ecf487a449dd4095479b292e3b463055a73a4e0db313eec3
F internal/ops/ops.go dd0d23f35d9258544c1d7f7395fdfd493241454a525c4edbdc7923a9b63f5ce4
F internal/ops/ops_test.go b1d4e8b120a5ee22516c3f0e871dd030045558f82f68ef1efdfe8de5152b4937
F internal/ops/spec.go b3244c2231bbebcb7824de2d35d0431cb83e4a8fcbb387a5b9f8ff0bd973622f
F internal/ops/spec_test.go 261f4d520b1fe3cbaa5f58e24feed2710c6636955298d5350c9a1e57405f7cb8
F internal/ops/validate.go 1f8810c9efd1cc2ab8f552082170a197063dd88b6ebcf8f894954256835a21cb
F internal/ops/validate_test.go 87b338b7a4bd197c3d18a8c5cdd3ab889ddb129f1fb749afb5dea36704de0fba
F internal/pikchr/pikchr.go ece27ccbf63f46e5cd8c001b4c74971b9ef40001ac49be249ff68814efc79fb1
F internal/pikchr/pikchr.wasm 25e93123be264aa53c1fbb255e5bfb148260b2e7e7d5959ba9dfb81d606ac387 x
F internal/pikchr/pikchr_test.go 28338cb47102a2c516c44167f1228aa48e09ff78d4cf56755009fe90bdd11908
F internal/semdiff/semdiff.go 36b9aa403d28fd0bc61926242ffc982ca02fd0c8b48344df3ebd1b19db1ce34a
F internal/semdiff/semdiff_test.go 3a0cd4ea5db38d80193248ceea0ba24ad89fb48623237abb96a668b77188d30e
F internal/web/assets/datastar.js d2e34bc82f964e41abaf1d6ee95cf6ad35c6560a859414a60ad82d5b22e5197a
F internal/web/session_test.go 522cc14de075e7c51528b3cc84f77d4c25a910fd8d66fff4949476b097483203
F internal/web/timeline.go c88e75bc0bb37edc83e54e6b3988addbe0042e60dbc663844d31ceefaba5c9ef
F internal/web/web.go a088eb9506b412053c0f39b31b4ba0a8d4552939d7cca23f5e288f3f423bdbb4
F internal/web/web_test.go 6d234772238195ba9d87346e7d62d58fcaf7aeac75c989e1483525734c9b9a8c
F internal/webhook/webhook.go 6b4b6fdb42449deba354c2484b18c0d128e880af13b0d45482960edc94370254
F internal/webhook/webhook_test.go 371d259da23ffdae1fdbd10ac6a2532a6165062f03cf1edfd1b107106cda9e46
F internal/xfer/container.go b427eb2780e8336cec7afcc36469776bd3a161bf1ab4908551c8ed6ff6cf207f
F internal/xfer/container_test.go 750f24c3c7683f8e25227f581a6b9ea9197c4aa5a19e0df53e2af9447e8f8fdc
F internal/xfer/xfer.go 09306a1700965adbfd21ab3cab38f7425c7dd3241099b5b9a3ceb3e6c9acbe69
F internal/xfer/xfer_test.go e0553e3981b98f82f74e5edc0381c1e233f7a73876071b7665b1c21d8029d798
F internal/zitcli/zitcli.go 0c09b2aa9bc1117421de70f7b1e912a795044c7adb4c45a9f3b48a1c92d3dbf7
F internal/zitcli/zitcli_test.go 9a7ad5640cc379a96639616cbf58021e552c27c2868fab1e563e7ec0ec991b64
F third_party/PROVENANCE.md 0a6f1c644e6ed6891e0fa4b7bce95041b8c637ffb8b1bb72e723fbb078be6d94
F third_party/sanitizer-corpus/forgejo.json 7ea9430d4f08428cd20ef5a2aaad2c5f47bc56def4a8d4b11296982d923c3025
F third_party/sanitizer-corpus/gitea.json 5989fba347b219c6a16bd2bc9b38802b750466b713c6ad465dcaac9195301b1c
F tools/timeline-verify.js 87354d9e75f50f1d3e6e175e47fff020401472dc8343d2107116918c7d1615dc
P adf5f7c322c69b082946bc5cbd6b2b9049afbd193e3be6219266dc073f58079c
R 8b675bc0871168eadb0cf83df42533d3
U dmestas
Z f1b233f959cb29333708698d3849fc88