Comment 29 for bug 203157

I'm seeing those CPU spikes too but they usually last 1 or 2 minutes, then everything goes back to normal.

It seems to me it's related to sqlite3, or to the history code as I see liferea deleting the same entries over and over again.

Here is how I saw that:

- start liferea that way: liferea --debug-all 2>&1 | tee /tmp/lf.log
- let it run for a while (several hours to a day)
- in a shell, try this: grep 'removing item with id' /tmp/lf.log | sort | uniq -c | sort -n | awk '{ print $1 }' | uniq -c

it will list how many time each unique item has been removed.

In my case, I get that:

      1 1
     21 2
    234 3
      1 4
     26 5
    176 6
      1 7
      9 8
      5 9
      1 10
      1 11
     19 12
      8 13
      3 14
      2 15
      4 16
     22 17
    669 18
      3 19
      3 20
     25 21
     16 23
     28 24
      8 25
     18 26
    855 27
   6450 28
   1175 30

I think that's what 1.4.18 is supposed to address..