UPDATES EasyBlog 6.0.18 Released! Update to the latest version

Helpdesk

Your Time
Our Time
Response Time
24 — 48 hours
We strive to provide the fastest ever response possible. However, we are not super beings.

Allow at least 24 — 48 hours
  Support is offline
It is currently off working hours and most of us aren't around

Rest assured that we will get back to you as soon as the day starts tomorrow!
  Support is offline

Huge number of DB queries

Jordan Weinstein · ·
11:24 AM Thursday, 23 April 2015
None
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
The replies under this section are restricted to logged in users or users with an active subscription with us