Hablamos Español

Support Center

Knowledgebase
View categorized listing of all common frequently asked questions.
Video Tutorials
Create a Movie & TV Show review website.
Customize the jReviews themes.
Review user profiles with the Everywhere addon.
Forum
Community forum
Submit a Ticket
Use your client area email to access the ticket system.
Downloads
Guides, modules and more...
Changelog

Sites using jReviews

Reviews Ahoy!

Friendly Sites

 
Welcome, Guest. Please login or register.
Did you miss your activation email?
January 07, 2009, 03:52:54 PM
 22774 Posts in 5217 Topics by 2974 Members
Latest Member: Vijitha
News: Use your client area email when you sign up to the forum so we can identify you as a trial or licensed user. Otherwise we may not answer your questions.
 
jReviews Support Forum  |  jReviews 1.x  |  General Discussion  |  Improving site performance « previous next »
Pages: [1] 2
Author Topic: Improving site performance  (Read 4171 times)
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8996
« on: May 13, 2007, 07:21:08 PM »
In jReviews 1.2RC3 the addition of indexes to the jReviews tables and improvements in queries have greatly contributed to better performance, reflected in faster loading pages. Not only that, but also many of the javascript libraries that were unnecessarily being loaded in all jReviews pages, now load only on the ones where they are needed. Another improvement was in the module thumbnails which are not correctly resized to the specified module size setting.

There's always room for improvement and in future version we will do our best to find more ways to decrease the number of queries.

Having said that, one aspect of jReviews which significantly increases the number of queries is the entry count in the directory, entry lists and the modules. By turning this setting off, the number of queries will be reduced significantly and that is the recommended setting: show entry count = NO in the component and modules.

Turning on the built-in Joomla cache will also have a significant improvement in page loads after they have been visited at least once after the cache expiration period.

Also read the performance recommendations at Joomla.org and the index queries to boost Joomla performance
« Last Edit: May 14, 2007, 09:29:49 PM by Alejandro » Logged
Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
bingoguy
Newbie
*
Offline Offline

Posts: 17
« Reply #1 on: May 21, 2007, 03:20:44 AM »
Thanks for the information.  I was waiting to see if there were any other posts to this topic, but I guess that I am the only one that doesn't quite get it. Huh  Where exactly do we "show entry count = NO"?  Do you mean not showing the total listings and reviews in the jrdashboard and sectionnav? 
Logged
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8996
« Reply #2 on: May 21, 2007, 08:35:43 AM »
No, I mean the count that appears in parenthesis next to the category name in the sectionnav module, the dashboard module (not the total listings and reviews mode), the jReviews directory and the jReviews category box. You can see the impact in queries if you enable the debug mode in your Joomla configuration settings.
Logged
Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
gigi
Full Member
***
Offline Offline

Posts: 90


WWW
« Reply #3 on: July 25, 2007, 02:56:06 PM »
just in case you have any info abou it.. Wink

does activating the joomla cache affect logged in users as well as guests?

how does the built in joomla cache fare in comparison to 3rd party caching applications (e.g. ircmaxell or joomlaatwork)?

thanks
gigi
« Last Edit: July 25, 2007, 02:58:24 PM by gigi » Logged
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8996
« Reply #4 on: July 25, 2007, 04:48:10 PM »
I have not tried the other caching applications, so I don't know. The Joomla cache does cache content for logged in users as well as guests.
Logged
Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
gigi
Full Member
***
Offline Offline

Posts: 90


WWW
« Reply #5 on: July 26, 2007, 09:30:08 PM »
update on that --> it does cache for logged in users, however, there's some odd behaviors exhibited! formattings disappear, drop-boxes keep resetting, and so on. i'll be forced to turn this off. i'm now testing the ircmaxell's pagecache for non-logged-in caching. if it will cache the products' directory that would be an advantage, and probably as far as it can reliably go at least on my site..
« Last Edit: September 11, 2007, 10:16:04 PM by gigi » Logged
serkany
Full Member
***
Offline Offline

Posts: 51
« Reply #6 on: December 04, 2007, 03:14:53 AM »
Any update on this? I also try to use ircmaxell's querycache component but I'm still making some tests. Does anyone have any experience?

Thanks,
Serkan
Logged
gigi
Full Member
***
Offline Offline

Posts: 90


WWW
« Reply #7 on: December 04, 2007, 05:58:21 AM »
i tried ircmaxell, it didn't cause any problems but i didn't notice a real significant increase in performance either. maybe it shows its merits on heavier sites. you can use it, but if your site is not very big, you can do without caching in my experience.
Logged
serkany
Full Member
***
Offline Offline

Posts: 51
« Reply #8 on: December 04, 2007, 06:38:23 AM »
My problem is with the server load. I'm using a shared server and there are load problems in the server. They say that my site is using to much CPU so I'm trying to solve it.

Pagecache supposed to decrease the page load times I guess but the documentation says that querycache from ircmaxwell is for the load and it has no effect on the page loading times. Hopefully it'l solve my load problems...

Thanks for the reply...
Logged
gigi
Full Member
***
Offline Offline

Posts: 90


WWW
« Reply #9 on: December 04, 2007, 06:41:48 AM »
unless you use highly inefficient code, what you need to do first and foremost is to switch hosts. i was hosting my site at one company and my site was very slow with the occasional cpu error. i switched to another company for $4 more / month and now it's almost faster than my local installation! and no cpu exceeded errors.

you can literally have your site run 10 times faster if you choose a good host.
Logged
serkany
Full Member
***
Offline Offline

Posts: 51
« Reply #10 on: December 04, 2007, 09:18:39 AM »
I can imagine that. Even small settings can change a lot. But in my case,  I think the extensions and plugins I use are not very efficient. There are a lot of queries for some pages. I saw 900 queries for a profile page cause there were a lot of items in the Articles tab of CB. This is the most extreme case but I had to work on these first.

Also I live in Turkey and need to find a server located in Turkey or Germany. I tried a server in US and the speed was considerably low. I think we have direct connection with Germany so it works as fast as hosted in Turkey...
Logged
gigi
Full Member
***
Offline Offline

Posts: 90


WWW
« Reply #11 on: December 04, 2007, 09:25:10 AM »
900 queries.. something's really wrong there. i have about 100 queries per page and that's considered a lot too.

you would be best asking about this in ircmaxell's forum:

http://www.joomlaperformance.com

or in joomla.org performance forum:

http://forum.joomla.org/index.php/board,268.0.html

gigi
Logged
serkany
Full Member
***
Offline Offline

Posts: 51
« Reply #12 on: December 04, 2007, 09:32:25 AM »
I think it's because of the article tab which has no pagination:) If a user has 300 items, then you have a problem. I also found one with pagination and will try that.

I already wrote in joomlaperformanca and joomla.org forums. But when I see this topic I just wanted to see how it worked for you.

Thanks for sharing your experiences...
Logged
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8996
« Reply #13 on: December 04, 2007, 09:40:16 AM »
Quote
I think it's because of the article tab which has no pagination:) If a user has 300 items, then you have a problem. I also found one with pagination and will try that.

You can retrieve 300 rows with a single query, or 1 million for that matter. The problem in this case would be if for every row another query is run. In your case, as an example, for every row, 3 additional queries would result in 900 queries.

So not having pagination doesn't necessarily impact the number of queries, unless you have the situation above, but it does impact memory usage because retrieving 300+ rows is not the same as retrieving 10-50 rows.
« Last Edit: December 04, 2007, 09:42:16 AM by Alejandro » Logged
Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
serkany
Full Member
***
Offline Offline

Posts: 51
« Reply #14 on: December 04, 2007, 05:15:02 PM »
I see your point but I compared different profiles and saw that the ones without any items have around 100 queries and number of queries increases with the number of items in that tab.  looks like 2 queries are run for each content item.

Code:
53
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=2051'54
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 2051
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
Logged
Pages: [1] 2
« previous next »
    Jump to:  


    Powered by MySQL Powered by PHP Powered by SMF 1.1.7 | SMF © 2006-2008, Simple Machines LLC
    Joomla Bridge by JoomlaHacks.com     		Valid XHTML 1.0! Valid CSS!