Joomla Templates Club 406,261 posts

[Ivan Friend IvanJoin date: March 2011Posts: 124Downloads:234Uploads:27 Thanks: 14 Thanked: 1 times in 1 posts]

#190658

Hello!

The problem is that the site with JA_Teline_4 is very slow — it takes from 8 to 15 sec to complete loading (with cache turned off).
After some inspections we found that the main problem is an enormous sql-querry generated by one of the components. After some experiments we found out that when the JA_News_Featured is turned off the load time is about 2-3 sec (cache turned off), when it’s back on – 10-15 sec. On other sites with this template and same set of extensions I see no such problems.

The cache is off because we have some modules with random content (articles, video, gallery, quotes…) and we don’t know why the option “No caching” for theese modules does not work properly. 3rd party extensions for cache does not work properly either: theese modules just wont change randomly.

We have already optimized everything we could: css, js, images, compression, turned off and on other modules and plugins, server is set up as it should… — everything of theese measures did give some effect, but this effect was insignificant if not to say null.

Please, tell us what is wrong. We’d like to have JA_News_Featured as well as 2-4 sec load time.

Site (temporary domain) sn.wdev.org
The querry:

<blockquote>SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a
.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.ordering, c.alias AS category_alias, LENGTH(a.fulltext) AS readmore,a.fulltext, a.id, a.title, a.alias, a.title_a
lias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.acces
s, a.hits, a.featured, a.ordering, c.alias AS category_alias, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS cate
gory_alias,CASE WHEN a.created_by_alias > ‘ ‘ THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as pa
rent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null
THEN c.published ELSE 0 END AS parents_published
FROM ukb1r_content AS a
LEFT JOIN ukb1r_content_frontpage AS fp ON fp.content_id = a.id
LEFT JOIN ukb1r_categories AS c ON c.id = a.catid
LEFT JOIN ukb1r_users AS ua ON ua.id = a.created_by
LEFT JOIN ukb1r_users AS uam ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM ukb1r_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN ukb1r_categories as parent ON parent.id = c.parent_id
LEFT JOIN ukb1r_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id as id FROM ukb1r_categories AS cat JOIN ukb1r_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = ‘com_content’ AND paren
t.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id
WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid IN (147) AND (a.publish_up = ‘0000-00-00 00:00:00’ OR a.publish_up <= ‘2
013-09-04 16:26:10′) AND (a.publish_down = ‘0000-00-00 00:00:00’ OR a.publish_down >= ‘2013-09-04 16:26:10’)
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam
.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.al
ias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.
images, a.urls
ORDER BY a.created DESC LIMIT 0, 5;</blockquote>

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#506037

Hi

Pls try to check the content that this JA News Featured module is retrieving from. As you can see in our demo site, it’s running as normal. You should also reconsider the usage of un-important / un-used content and extensions.

And the important thing is that the cache should be enabled ( in template manager).

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#506038

Hi

Pls try to check the content that this JA News Featured module is retrieving from. As you can see in our demo site, it’s running as normal. You should also reconsider the usage of un-important / un-used content and extensions.

And the important thing is that the cache should be enabled ( in template manager).

Check out this tips for more info: http://www.joomlart.com/blog/news-updates/tools-and-tips-to-check-joomla-site-speed-and-improve-performance

[Ivan Friend IvanJoin date: March 2011Posts: 124Downloads:234Uploads:27 Thanks: 14 Thanked: 1 times in 1 posts]

#506062

Thank you for your attention.

The content for this module is taken from only 1 category.
And about other extensions – as I’ve said before, we have cut everything unnecessary, turning off and on one by one plugins and modules.
Now with template cache on GTmetrix shows 12 sec page load time

By the way – template-native js compressor doesn’t work well: with switched on the drop-down menu, prev-next buttons and rotators do not work. So only css comprssion is on.

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#506662

<blockquote>By the way – template-native js compressor doesn’t work well: with switched on the drop-down menu, prev-next buttons and rotators do not work. So only css comprssion is on.</blockquote>

Could you post your site URL here for further checking?

[Author]

Posts