Artifact c754084dc7785c2efac55e686017fada95773fd1928e0196ce5e755aa9386460:
Three separate faults, worst first.
Branches() used a correlated subquery — one full scan of checkin per row. On tcl (42,074 check-ins, 1,855 branches) that took 434 SECONDS, which is what made the page look hung rather than slow. One grouped scan with SQLite's bare-column-with-max rule, plus an index on (branch, date): 0.042s.
'ls --long' costs ~4ms per file because it reads each blob for size and the binary flag, so tcl's 2,198-path tip took 8.5s. Fossil never pays this — browse.c builds a directory listing from its own indexed tables and shows no size at all — but quarry reads through the CLI by design, so the answer is to compute once: a check-in's file set is IMMUTABLE, so listings are memoised per version, the tip is warmed after each ingest, and the tree op resolves 'trunk' to its hash so the page asks for the key that was warmed.
Only a hash may be cached. Caching 'trunk' would serve a stale tree forever after the next commit — a correctness bug dressed as a performance fix — so the memo refuses anything that can move, with a test pinning it.
The branch selector rendered every branch: 1,855 <option> elements, 90% of a 239KB page, and unusable as a control. Now the 25 most recently active, plus the branch being viewed even when it is older.
tcl's repo home: 8.5s -> 0.38s, 239KB -> 29KB. sqlite: 5.0s -> 0.32s. by dmestas on 2026-08-17 15:52:12.
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