Artifact c90b4c28e21e7e3e370dfd384b43cf8b7922d621:

Ticket change [c90b4c28e2] - New ticket [a82652e221] `fossil annotate' is unusably slow. by anonymous 2011-03-25 01:42:14.

---

D 2011-03-25T01:42:14.434
J comment I\sdownloaded\sthe\sNetBSD\sfossil\srepository\sat\r\n\r\n<http://ftp.NetBSD.org/pub/NetBSD/misc/repositories/fossil/src.fossil>,\r\n\r\nopened\sit\swith\s`fossil\sopen\s../src.fossil',\schose\sa\sfile\sat\srandom,\sand\r\ntried\sto\sannotate\sit\swith\s`cd\ssrc/sys/dev/usb\s&&\sfossil\sannotate\r\nuark.c'.\s\sIt\stook\sover\san\shour\sbefore\s`fossil\sannotate'\sbegan\sto\swrite\r\nany\soutput.\r\n\r\nAround\sforty\sminutes\sin,\sI\sktraced\sthe\sfossil\sprocess\sfor\sa\sminute\sor\r\nso,\swhich\srevealed\sthat\salmost\severything\sit\swas\sdoing\swas\spwrite.\r\niostat\sreported\sthat\sit\swas\shammering\sthe\sdisk\s--\swriting\s20\smegabytes\r\nper\ssecond.\s\s(Nothing\selse\son\sthe\smachine\swas\sdoing\ssubstantial\sdisk\r\nI/O\sthen.)\r\n\r\nAfter\sit\scompleted,\sI\sstarted\sit\sup\sagain\swith\s`fossil\s--sqltrace\r\nannotate\suark.c',\sand\sall\sthe\soutput\sI\shave\sseen\sso\sfar\sis\sof\sthe\sform\r\n\r\nSELECT\sa.pid,\sb.mtime\sFROM\splink\sa\sLEFT\sJOIN\splink\sb\sON\sb.cid=a.pid\sWHERE\sa.cid=N;\r\nINSERT\sOR\sIGNORE\sINTO\sok\sVALUES(M);\r\n\r\nwhere\sN\sand\sM\sare\spositive\sintegers\sthat\sare\snearby\sone\sanother\sand\r\nboth\sare\sdecrementing\sbut\sdon't\sseem\sto\sbe\sequal.
J foundin 4a2019ddd0
J private_contact 5997cbe2835ebb6f36685b0646aff444c56cd556
J severity Critical
J status Open
J title `fossil\sannotate'\sis\sunusably\sslow
J type Code_Defect
K a82652e2216d2cfefc9c4ee90aa31266dde7f5d4
U anonymous
Z b34fa971200bf1333bf3d4722a7f00e0