Hi,
I have noticed that EasyBlog 3.9 has started to seem slow. When debugging the EasyBlog page, over 500(!) queries were being made, almost half from EasyBlog. I changed SEO settings to default to a set itemid and this helped a little but there are still lots of queries slowing the page down. Same with Komento. I realize that query number alone is not the only issue affecting speed of loading page but this seemed excessive. Queries pasted below (cache on):
68 × SELECT *
FROM pref_easyblog_post
24 × SELECT a.`id`, a.`title`, a.`alias`
FROM `pref_easyblog_tag` AS a
LEFT JOIN `pref_easyblog_post_tag` AS b
ON a.`id` = b.`tag_id`
24 × SELECT COUNT(1)
FROM `pref_easyblog_featured`
24 × SELECT COUNT(1)
FROM `pref_easyblog_tag`
24 × SELECT a.`team_id`
FROM `pref_easyblog_team_post` AS a
INNER JOIN `pref_easyblog_team` AS b
ON a.team_id = b.id
24 × SELECT a.*
FROM `pref_easyblog_comment` a
24 × SELECT AVG(value) AS ratings, COUNT(1) AS total
FROM `pref_easyblog_ratings`
24 × SELECT *
FROM `pref_easyblog_ratings`
24 × SELECT a.*
FROM `pref_easyblog_post` as a
22 × SELECT *
FROM pref_easyblog_tag
6 × SELECT *
FROM pref_easyblog_users
5 × SELECT *
FROM `pref_easyblog_acl_group`
3 × SELECT *
FROM pref_easyblog_category
3 × SELECT value
FROM pref_jfbconnect_config
3 × SELECT COUNT(1)
FROM `pref_easyblog_category`
17 × SELECT COUNT(1)
FROM `pref_komento_comments`
15 × SELECT COUNT(1)
FROM `pref_komento_actions`
10 × SELECT COUNT('1') AS `total`
FROM `pref_komento_comments`
10 × SELECT `rules`
FROM `pref_komento_acl`
6 × SELECT AVG(`ratings`) as `value`, COUNT(1) AS `total`
FROM `pref_komento_comments`
6 × SELECT *
FROM `pref_komento_comments`
5 × SELECT *
FROM pref_komento_comments