sheepcow/XenQuotation — Issue #34: Slow Query
Author: xOBKx
Created: 2011-10-25 13:51:56+00:00
State: open

UPDATE xq_quotation SET views = views + 1 WHERE quote_id = ?

This query appears to be causing extremely slow load times on my XenForo installation. It executes wherever the sidebar block is used.

With debug mode enabled, at one stage I recorded this result;
Params: 74
Run Time: 7.905001
Does this indicate that it's updating the view count for EVERY Quote, and not just the one on display?

Either way, disabling XenQuotation gave an almost instant speed boost.. :(