[jonty]

We've a large-ish forum with 95k threads and almost 175k posts.
We get an intermittent delay when posting replies to non-bookie threads as well as delays when posting vbookie events.

Turns out it was a delay in a query

SELECT item.item_id, item.item_title, item.threadid, grp.group_title, item.item_status, item.item_created, item.item_open_until, item.item_pay_after, thread.threadid, thread.forumid, thread.postuserid
                 FROM vbookie_items AS item
                 LEFT JOIN vbookie_groups AS grp ON grp.group_id = item.group_id
                 LEFT JOIN thread AS thread ON thread.vbookie_item_id = item.item_id
                 WHERE item.item_status='SETTLED'
                 ORDER BY  item.item_id DESC
                 LIMIT 880, 20;

The simplest solution was to add an index on the mysql table 'thread' on the vbookie_item_id column. :up: