Knowledgebase
View categorized listing of all common frequently asked questions.
Video Tutorials (jReviews 2.0)
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...
Reviews Ahoy!

Extensions we recommend

CSV Import for Joomla and jReviews
 
Welcome, Guest. Please login or register.
Did you miss your activation email?
December 03, 2008, 08:04:52 PM
 21745 Posts in 4968 Topics by 2846 Members
Latest Member: alaiing
News: Do not post any jReviews files or large amounts of code in the forums please. Only template files and code are allowed.
 
jReviews Support Forum  |  jReviews 1.x  |  General Discussion  |  Improving site performance « previous next »
Pages: 1 [2]
Author Topic: Improving site performance  (Read 3988 times)
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8622
« Reply #15 on: December 05, 2007, 12:00:59 PM »
I think these queries are run by the function $mainframe->getItemid which is VERY inefficient. It gets the correct menu id (Itemid in the url) for each content, but instead of receiving an array with all the content ids, it is run for each one.
Logged
Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
Tomasz2
Newbie
*
Offline Offline

Posts: 10
« Reply #16 on: February 18, 2008, 05:29:28 AM »
Hi, I just wanted to add that I was experiencing the same problems with joomla cache as gigi.

When I turn it on, some review pages are formatted incorrectly (they are all black and white, as if no css styling was used) and ajax is not working so it's impossible to write a review.

I even saved the same page with cache off (looking ok) and cache on (the aforementioned problems present) and it turned out that the html file size difference is ca. 10 kilobytes i.e. when the cache is on the page size is 10 kb smaller. It looks like  there is a lot missing in the output.

I turned off the cache and never bothered but it would be a nice addition to an overall great package if I could use the cache.

Take care!
Logged
richrf
Newbie
*
Offline Offline

Posts: 11
« Reply #17 on: May 02, 2008, 08:52:12 AM »
Hi,

Has anyone had a chance to go through the code thoroughly and analyzed which application functions slow down performance the most?For example, does adding additional custom fields create additional table joins which in turn degrade performance?

Also,  has anyone analyzed the SQL Explains in order to ensure that indexes are always being used and are being used correctly? In other words, has an SQL expert examined all the queries for logical database and physical database optimization? Has different versions of the MySQL optimizer affected the performance of the system? Thanks for any info.

Rich
« Last Edit: May 02, 2008, 09:04:06 AM by richrf » 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!