All Albums view is uber slow.
By Matt on Wednesday, 24 February 2016
Posted in Technical Issues
Replies 14
Likes 0
Views 460
Votes 0
When going to the All Album view it is very slow to process and display on the browsers. Other views respond almost instantly and start appearing in the browser but there is a big lag when viewing albums.

Check out here: http://gamersnaps.com and click on browse.
Hi Matt,

Regarding your albums browse page, I've added a fix and now it is the page load is much faster I also did some adjustment to number of items listed on a page from 20 items to 10 item so that the page load will be after and less item to process.

Anyway, it seems like now your page was cached? I noticed the page no longer retrieve the photos from your Amazon S3 but the photo thumbnail link is still pointing to S3. Did you enabled any server caching? e.g pagespeed caching?


For your information, the fix that i applied to your albums page will be added into next release of EasySocial as well

Hope this help and have a nice day!
Sam
·
Friday, 26 February 2016 12:33
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Matt,

I am sorry for the delay of this reply.

Regarding your issue, can you provide me the htaccess credential so that I can login to your EasySocial backend and check for some settings?

Please i noticed when I first load the album browse page, look like the connections to your S3 are pretty slow. Please see http://screencast.com/t/AYLQxri72vCw Not sure if this related to where I am connecting to your site.

Please advise.
Sam
·
Thursday, 25 February 2016 13:01
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Sam,

I have removed the htaccess permissions so you should be able to access now.

I have tested the site at a few different places and it is always the initial request that takes the longest and is what is experienced (e.g. the page doesnt even start loading for several seconds).
Matt
·
Thursday, 25 February 2016 18:49
·
0 Likes
·
0 Votes
·
0 Comments
·
It also also very slow when clicking on an album to view as this uses the same location (e.g. /browse on my site)
Matt
·
Thursday, 25 February 2016 18:54
·
0 Likes
·
0 Votes
·
0 Comments
·
Why is it that the browse page is downloading the large images when it is not displaying them? (and still needs to load/download them when clicking on a thumbnail to view).
Matt
·
Thursday, 25 February 2016 20:48
·
0 Likes
·
0 Votes
·
0 Comments
·
Any further assistance with this? It is driving me nuts. Looking at an album without many pictures displays on the browser much quicker than one with many, as if the script is trying to gather all the pictures before sending data back to the browser causing a massive wait for users (rather than loading on the screen as data is fetched).
Matt
·
Friday, 26 February 2016 01:49
·
0 Likes
·
0 Votes
·
0 Comments
·
I have noticed the All albums view is making over 500 SQL queries.... that seems a bit excessive?

Also only just noticed I put this thread in the wrong place, sorry!
Matt
·
Friday, 26 February 2016 02:06
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Matt,

I am really sorry for the delay of this reply.

Thanks for fixing the htaccess. I am currently checking on your issue and I will get back to you at soonest
Sam
·
Friday, 26 February 2016 10:15
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Matt,

Anyway, it seems like now your page was cached? I noticed the page no longer retrieve the photos from your Amazon S3 but the photo thumbnail link is still pointing to S3. Did you enabled any server caching? e.g pagespeed caching?


Regarding the above, I am sorry for the confusion. I was due to my previous fix causing the photo not loaded. I've corrected the issue and now the photos are retrieving from your Amazon S3.

However, the connection to your Amazon S3 are very slow to load a photo Please see: screencast.com/t/9HWkkykDkMLs It seems like it taking very long time to load a single photo from S3
Please advise.
Sam
·
Friday, 26 February 2016 12:46
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Sam,

Thanks for the help, it is indeed functioning quicker now. Still a small wait but much improved.

I did have Joomla set to conservative caching - is it best to keep this off?

Will look into the S3 problem.

Thanks again!
Matt
·
Friday, 26 February 2016 17:04
·
0 Likes
·
0 Votes
·
0 Comments
·
Is there a way to integrate Amazon CloudFront with easysocial?

This would mean that people are served the images from a location nearest to them and speed things up considerably.
Matt
·
Friday, 26 February 2016 18:44
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Matt,

I am sorry for the delay of this reply as now is a weekend for us here

>> I did have Joomla set to conservative caching - is it best to keep this off?

Don't worry, you can keep your caching enabled on your Joomla

>> Is there a way to integrate Amazon CloudFront with easysocial?

If you want to use Amazon cloudfront, you will need to have CDN enabled in your EasySocial as well. There are few discussion regarding this cloundfront and below are some of them:

http://stackideas.com/forums/anybody-got-cloudfront-cdn-and-nonumber-cdn-for-joomla-working-on-es-site-with-updates-showing-as-they-are-made
http://stackideas.com/forums/please-also-use-cloudfront-on-s3-remote-storage-option
http://stackideas.com/forums/issue-with-albums-when-cdn-cloudfront-enabled

Hope these helps
Sam
·
Saturday, 27 February 2016 15:30
·
0 Likes
·
0 Votes
·
0 Comments
·
Excellent thanks for all the help!!

I have not had much luch getting CloudFront to work but don't want to derail this thread. Any chance this will be implemented in next version?

Thanks again!
Matt
·
Saturday, 27 February 2016 18:33
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Matt,

You are most welcome. Glad to hear that your issue has been resolved now.

‘we will see if we can add this feature into next future release or not.'
jasni jasman
·
Monday, 29 February 2016 10:21
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post