I've noticed that most the pages are loading on my site normally accept for some pages involving JomSocial. I've gone to the JomSocial boards for their help, but they couldn't nail down anything. I went to my Host (we're on VPS) and they couldn't pin down exactly what it is, but they said it was SQL queries that were likely the culprit.
I got the freeware of some query monitoring software (jetprofiler) and downloaded a copy of my site to my local machine. The freeware omits most of its findings until you buy there software, but what I did find is that Acymailing was firing off a query with every page load.
UPDATE joom_acymailing_subscriber SET filterflags = REPLACE(filterflags, "f17f", "") WHERE filterflags LIKE "%f17f%"
I presume that this is happening with all my filters that are ticked for "every time acymailing is triggered", so I unticked these. as I currently have over 180 filters and roughly half of those were on "every time acymailing is triggered" and that one query alone has a join size of 4,845 rows. I guess my question is, why are acymailing queries being triggered on jomsocial page loads? can I get that behavior to stop?