Ticket Change Details
Not logged in
Overview

Artifact ID: c90b4c28e21e7e3e370dfd384b43cf8b7922d621
Ticket: a82652e2216d2cfefc9c4ee90aa31266dde7f5d4
`fossil annotate' is unusably slow
User & Date: anonymous 2011-03-25 01:42:14
Changes

  1. comment changed to:
    I downloaded the NetBSD fossil repository at
    
    <http://ftp.NetBSD.org/pub/NetBSD/misc/repositories/fossil/src.fossil>,
    
    opened it with `fossil open ../src.fossil', chose a file at random, and
    tried to annotate it with `cd src/sys/dev/usb && fossil annotate
    uark.c'.  It took over an hour before `fossil annotate' began to write
    any output.
    
    Around forty minutes in, I ktraced the fossil process for a minute or
    so, which revealed that almost everything it was doing was pwrite.
    iostat reported that it was hammering the disk -- writing 20 megabytes
    per second.  (Nothing else on the machine was doing substantial disk
    I/O then.)
    
    After it completed, I started it up again with `fossil --sqltrace
    annotate uark.c', and all the output I have seen so far is of the form
    
    SELECT a.pid, b.mtime FROM plink a LEFT JOIN plink b ON b.cid=a.pid WHERE a.cid=N;
    INSERT OR IGNORE INTO ok VALUES(M);
    
    where N and M are positive integers that are nearby one another and
    both are decrementing but don't seem to be equal.
    
  2. foundin changed to: "4a2019ddd0"
  3. private_contact changed to: "5997cbe2835ebb6f36685b0646aff444c56cd556"
  4. severity changed to: "Critical"
  5. status changed to: "Open"
  6. title changed to: "`fossil annotate' is unusably slow"
  7. type changed to: "Code_Defect"