UPDATES EasyBlog 6.0.14 Released! Joomla 5.x and PHP 8.x compatible now!

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 online
Our support specialists is available now. We will attend to you as soon as we can.
  Support is online

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