Thanks for sharing By the way, I am just wondering if you guys are running on innodb or myisam?

it is a shared hsoting ,I have no idea

Thanks for updating

continuing the speeding trics

the bset option I had is to enable APC cahc in cpanel and also in joomla backend to progressive

Thanks

I compared memcached and APC, and in my tests APC had better results... But, I am sure that others have had different results.
My best results have been the following combo: nginx php-fpm APC

@Laursen : do you have the problem to clear apc chach ?
when I goto clear cach through backend t shows nothing,and when I enable debug it shows error no index,do u have any idea why ?

the only way to clear cach at my end is to install a plugin for that

@aelsharawi : No, I have not had a single issue. I had many problems with memcached, but not a single problem with APC.

I had a chance to look at my DB ,it is mixed some is innodb and others is myisam .....easysocial&easydiscuss is myisam

Also I found these errors when trying to optimize the DB:

Problems with indexes of table `jos_social_clusters_categories_access`

 The indexes category_id and category_id_2 seem to be equal and one of them could possibly be removed.

Problems with indexes of table `jos_social_discussions`

 The indexes PRIMARY and id_2 seem to be equal and one of them could possibly be removed.

Problems with indexes of table `jos_social_subscriptions`

 The indexes uid_type and uid_type_email seem to be equal and one of them could possibly be removed.

Problems with indexes of table `jos_user_keys`

 The indexes series and series_3 seem to be equal and one of them could possibly be removed.

 The indexes series and series_2 seem to be equal and one of them could possibly be removed.

Is it signinfcant ?

also found this one:

aaa_jos2.jos_finder_tokens

check

note

The storage engine for the table doesn't support c...

aaa_jos2.jos_finder_tokens_aggregate

check

note

The storage engine for the table doesn't support c...

ah lol, upon further investigation I can confirm that EasySocial is running MyISAM.

Thanks for the heads up on this aelsharawi, we'll remove those duplicate indexes on jos_social_* but it really doesn't harm anything As for the other tables, they are actually from Joomla and I think it's perfectly fine

CHECK THIS:

http://www.slideshare.net/siteground/speed-new-jdnlfinal

Guys,

Currently there is a problem with easysocial DB structure. Stackideas team is working on this. Something (with its DB) kills Easysocial performance .

After fixing DB issue, We can boost our web sites, I have some special technics I will write here

Thanks Gokhan, I look forward to learning these techniques you are talking about.

Thanks for sharing gokhan

I also need to know this issue which causes performance issues....

unfortunately the gzip compression will break auto-posting to facebook if you are auto-posting from EasyBlog. This is NOT a problem that EasyBlog can fix. It has been submitted to facebook as a bug. Hopefully they will choose to fix this problem soon. Otherwise you will have to turn off Gzip compression in order to use Auto-Posting.

The DB can explain slow server respond time 0.6 sec on my server

subscribed

There has been some issues with "duplicated sql queries" being executed because the code was ideally added to cache those SQL queries and ensured that it only gets executed once the whole time. However, there seems to be some modifications along the road in EasySocial 1.2 (This is just one of the reasons why we should stop adding new features in maintenance releases, lesson learnt!) and these "performance optimized" codes ended up generating twice the amount of SQL query on the site.

Apart from that, we have also reduced the dependency on loading user's custom fields every time the page renders on the site. Instead, we only poll it when the custom field or app requires it.

With the test data provided by gokhan, I was able to reduce the load time from 3.2s -> 2s (By disabling cometchat and jquery easy) . Then, from there we were able to fine tune it down to 1.4s - 1.6s

Hi Mark,

Can't wait to check the optimized version.... I migrated from JS and I appreciate your support and products very much!

Subscribing.

Thanks Horst

continuing the enhancment tips:

here is sugession from google page speed:

Leverage browser caching

Setting an expiry date or a maximum age in the HTTP headers for static resources instructs the browser to load previously downloaded resources from local disk rather than over the network.

Leverage browser caching for the following cacheable resources:

http://website.com/…ml=1&controller=foundry&task=getResource (60 minutes)

http://website.com/…dia/com_easysocial/fonts/easysocial.woff (60 minutes)

ALSO there were incompatiablity betwen APC in php 5.5 so I had to revert to 5.4

Hello Aelsharawi,

These are not really critical but we cannot fix this internally unfortunately. it needs to be done by your web server (htaccess) file.

subscribed

Hm, perhaps we should really add a subscribe button here in the forums

Yes please Mark!

@Mark, to follow-up on your idea It would be nice to have either "subscribe" which leads to automatic e-mail notification when the thread has been updated, or a "watching" which does not result in an e-mail notification but does allow users to view "Watched" threads from their Forum Profile as I show in the attached image. Clicking "Watching" would show all the discussions of interest to them for later reference. Great way to organize developing, debugging, and/or inspirational content.

Thanks for the heads up on this Eileen!

Very excellent suggestion. I would love for my EasyDiscuss to do that as well!

http://www/?option=com_easysocial&tmpl=component&no_html=1&controller=foundry&task=getResource

so can you suggest the httaccess for that

I got the font:

ExpiresByType font/truetype "access plus 1 month"

	ExpiresByType font/opentype "access plus 1 month"

	ExpiresByType application/x-font-woff "access plus 1 month"

	ExpiresByType image/svg+xml "access plus 1 month"

	ExpiresByType application/vnd.ms-fontobject "access plus 1 month"

Hello Aelsharawi,

Those AJAX requests should not be cached and I don't think that there's anyway to cache and ajax request either.

Having added ES/EB/K and Kunena to my J2.5 site it was bogging down so I spent some time with YSlow and Google page tools to try to eradicate all bottle necks. I ended up doing the following (and achieving a worthwhile reduction in page load times)

These are my htaccess additions.

<IfModule mod_expires.c>

ExpiresActive On

ExpiresByType text/html "access plus 1 seconds"

ExpiresByType image/gif "access plus 2 years"

ExpiresByType image/jpeg "access plus 2 years"

ExpiresByType image/png "access plus 2 years"

ExpiresByType text/css "access plus 2 years"

ExpiresByType text/javascript "access plus 2 years"

ExpiresByType application/x-javascript "access plus 2 years"

ExpiresByType image/ico "access plus 2 years"

</IfModule>



<ifModule mod_headers.c> 

Header set Connection keep-alive 

</ifModule>



<IfModule mod_headers.c>

  <FilesMatch "\.(js|css|xml|gz)$">

    Header append Vary: Accept-Encoding

  </FilesMatch>

</IfModule>



<IfModule mod_deflate.c>

AddOutputFilterByType DEFLATE text/plain

AddOutputFilterByType DEFLATE text/html

AddOutputFilterByType DEFLATE text/xml

AddOutputFilterByType DEFLATE text/css

AddOutputFilterByType DEFLATE application/xml

AddOutputFilterByType DEFLATE application/xhtml+xml

AddOutputFilterByType DEFLATE application/rss+xml

AddOutputFilterByType DEFLATE application/javascript

AddOutputFilterByType DEFLATE application/x-javascript

AddOutputFilterByType DEFLATE image/x-icon image/svg+xml

AddOutputFilterByType DEFLATE application/vnd.ms-fontobject

AddOutputFilterByType DEFLATE application/x-font-ttf

AddOutputFilterByType DEFLATE font/opentype

</IfModule>





<FilesMatch "\.(ico|pdf|flv|jpg|jpeg|png|gif|js|css|swf)$">

Header set Cache-Control "max-age=2592000, public"

</FilesMatch>

I also added JCH Optimize plugin . That needs some fine tuning to make sure everything still works and you're not competing with existing compression option in Joomla and components but it was certainly worthwhile and I went through quite a few iterations.

GZIP was the interesting one. Switching in on in the global config did not actually enable it. I had to add the deflate statements in the htaccess to make it work.

I am no htaccess expert - I got these from scouring various articles on fixing the errors hightlighed by YSlow.

Nice, thanks for sharing Richard. Setting an expiration date for these files are good because this would tell the browser to cache these files.

just4info: for modifying the htaccess file from joomla i would like to suggest "admin tools", specially the option "htaccess maker" from this tool.

subscribe

Thanks for the heads up on this n00bster

Subscribe

Just curious if these changes have been added to a production release yet. Thanks!

Thanks Horst

Mark wrote:

There has been some issues with "duplicated sql queries" being executed because the code was ideally added to cache those SQL queries and ensured that it only gets executed once the whole time. However, there seems to be some modifications along the road in EasySocial 1.2 (This is just one of the reasons why we should stop adding new features in maintenance releases, lesson learnt!) and these "performance optimized" codes ended up generating twice the amount of SQL query on the site.

Apart from that, we have also reduced the dependency on loading user's custom fields every time the page renders on the site. Instead, we only poll it when the custom field or app requires it.

With the test data provided by gokhan, I was able to reduce the load time from 3.2s -> 2s (By disabling cometchat and jquery easy) . Then, from there we were able to fine tune it down to 1.4s - 1.6s

Hello Barkley,

Yes, it is already in the production version We have currently just signed an NDA with a customer of ours as they are willing to share their database with us for us to run some test cases and case studies so that we can improve on our SQL queries.

Just for your information, they have a very very huge user base and they have close to 800k activity items for us to play around with. With these data available for us, I am pretty sure we'll be scoring better results after this

Great! Thanks!

Sounds very exciting

Yep, we're excited and waiting for them to send the database over

Subscribing

Thank you for subscribing Sunny!

subscribe

For our site we have a Page load time of 4.48s and I'm guessing many visitors are leaving our site because of that.

Our site is hosted on Siteground (Cloud VPS)
We're using CloudFlare for CDN
We're using JCH Optimize Pro for optimizing

Please tell me if there's any improvements I can make.

Link to our site http://www.queertownabbey.com/

Anders

Stop using JCH Optimize. Sites as complex as EasySocial based ones tend to slow down with it. Use Mod_Pagespeed which does the same, but server side. It is way better. That said, depending on your hosting and your experience level, that may or may not be a viable option.

Thanks for your reply Jannik,

With JCH Optimize disabled the Page load time is 4.14s.

I'm not sure if Mod_Pagespeed is possible for Cloud VPS on Siteground without buying the expensive Cloud Performance Booster (120.00 EUR for 3 months)

Got this reply back from Siteground

By default mod_pagespeed is installed on our Cloud VPS hosting plans and it does not require the Cloud Performance Booster.

Please note that the Performance Booster includes Varnish and Memcached, plus our Super Cacher plugin.

Is the Cloud Performance Booster worth to purchase?

Varnish doesn't work well with Joomla. Unless you invest in a modified version of Joomla. Memcached works great for database, but is not ideal for regular joomla caching. Super Cacher I have never tried.

All in all, I don't think it is worth the money. Just enable and configure mod page speed via your htaccess

Could you please tell me how to enable and configure mod page speed via htaccess

@Anders, wish I had an answer but instead I have questions Your homepage loaded with no perceptible delay whatsoever when I first clicked, however, when attempting to access a Group I stopped waiting and left (I have attention deficit disorder take a look here if I'm seeing this delay perhaps other visitors are as well.

Interestingly, if I use pingdom to check the URL you'll find a js file http://www.screencast.com/t/1fWfYkqW responsible for almost 2 seconds of the delay. When I attempt to check out the site where this js is fetched, I get a message http://www.screencast.com/t/U0WZ6Zc0osVK saying that site took too long to respond and the request timed out.

Note to SI: If I enter those screencast URLs as links with the editor they won't work.

Hello Anders,

As Jannik pointed out, scrap JCH Optimize or any other system plugins that you have which will manipulate the HTML codes. EasySocial uses extensive HTML 5 structure where there are lots of "data-" attributes on the page. What most of these plugins does is scan through the HTML codes on the page and will actually cause a huge slowdown of your site.

If you want me to inspect on which plugins are problematic for your site, please start a new thread on our forums and provide us with:

1. Site backend access
2. FTP access

Thanks for your reply Eileen.

I have never seen the issue with the groups before. I'm not getting any javascript error so don't know how to solve it.

I have removed the siteapps plugin and I'm down to Page load time: 3.76s (GTMetrix)

Thank you Mark for being willing to look at this,

I have actually implemented JCH-Optimize because without it my site is so slow that nobody will stick around. So, I would be happy for you to poke around and advice on ways to improve it. I will definitely take you up on your offer to look at the site and will create a new forum post . As it is now the site is still slow, even with JCH-Optimize but at least it is not painfully slow. I get 9 second load times without the plugin.

Thank you, Sean
PS. My site is at https://www.Starch-Smart.com

Mark wrote:

Hello Anders,

As Jannik pointed out, scrap JCH Optimize or any other system plugins that you have which will manipulate the HTML codes. EasySocial uses extensive HTML 5 structure where there are lots of "data-" attributes on the page. What most of these plugins does is scan through the HTML codes on the page and will actually cause a huge slowdown of your site.

If you want me to inspect on which plugins are problematic for your site, please start a new thread on our forums and provide us with:

1. Site backend access
2. FTP access

Okay I will start a new thread Mark.

Thank you Anders