By Jordan Weinstein on Thursday, 23 April 2015
Posted in General Issues
Replies 3
Likes 0
Views 871
Votes 0
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
Hello Jordan,

I am sorry for the delay of this reply. The DB queries is depends on the total number of post or items that are available in your easyblog single current page. Perhaps you can try to lower down the post list limit at your frontpage to reduce the number of DB queries of your page or try to reduce down the numbers of modules to be displayed at your easyblog page.
·
Thursday, 23 April 2015 20:33
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

I am simply using the front page menu item to display my blog. There are approximately 50 posts in the blog in total. I'm not certain how else this is supposed to be used then. I can't imagine that creating 500 database queries is the expected behavior for showing the front page of a blog.

Jordan
·
Friday, 24 April 2015 06:31
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Jordan,

Can you provide us with your joomla backend and FTP access so we can check on the DB queries and its relation with your setting from backend? Please advise
·
Friday, 24 April 2015 16:22
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post