I have a big forum with million + daily page views.
After installing this mod my traffic is increasing from google but cpu usage has spiked to 4 times more. I upgraded the server but this mod is taking 80% resources of server.
I think this query is problem
SELECT id_tag, status, hits, tag
FROM smf_googletagged
WHERE id_topic = 56722 AND status != 0
ORDER BY RAND()
LIMIT 20
Is there a way to make this query use less cpu?
Also when i click on tag on topic it redirects me to homepage