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 offline
Our team is away during the weekend. Some answers may already be available on our documentation

Rest assured that we will get back to your posts as soon as the week starts!
  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