ISSUE SUMMARY:
Hi please check crushontube.com - it is in joomla offline and debug mode at the minute. You will notice
Time: 5107.46 ms / 5328.88 ms Memory: 409.841 MB / 425.44 MB Application: afterRenderComponent com_community it is this component which is taking 5-6 seconds to load on COT haome page even when its offline - needs googling or taking jomsocial team's help
Database queries total: 1119.63 ms
446 Queries Logged 1119.63 ms
336 duplicate found! :O
SELECT `id`
FROM `jos_users`
WHERE id='0' has been called 217 times :O


STEPS TO REPLICATE:
1 - just load crushontube.com
2
3
4
5
RESULT - very slow loading even in offline mode or not loading at all. Consumes too much RAM.
EXPECTED RESULT - should load in 2-3 seconds.
BROWSER - chrome/firefox

PS: I just renewed my subscription to get support on crushontube.com however I couldn't find an option to change the domain name we need support on. We have discontinued roomsforfavours project and shutting that down. fields below are not allowing me to enter crushontube.com anywhere. however admin id and password is mentioned below.

Hi Navin,

Please you try to disable module members, and let me know how its going.

thank you!

Hi Dimas,

After disable members module - no luck (load slow)

I have upgraded jomsocial and still loading slow. Please look into it.

Time: 5033.21 ms / 5216.85 ms Memory: 409.638 MB / 423.60 MB Application: afterRenderComponent com_community
Database queries total: 1009.78 ms

Memory Usage: 425.78 MB (446,466,640 Bytes)

436 Queries Logged 1009.78 ms

326 duplicate found!

Hi Navin,

Where can I test it?I cant access this site roomsforfavours.com on my end, maybe you blocked the Indonesian IP to access your site?

thank you!

Hi Dimas,

You need to check crushontube.com and loveinlondon.net.

Thanks!

Hi Navin,

I just checked your site crushontube.com and load normally, its fast enough..

Hi Navin,

I just checked your site crushontube.com and load normally, its fast enough..

Hi Dimas
This server has 5-6 similar sites with similar userbase (actually the biggest userbase one has no issues) but crushontube.com and loveinlondon.net suddenly started crashing last week due to low memory. memory_limit was 256MB in PHP.ini which was fine for other sites but not for these two. Also jomsocial component in the backend was throwing errors in loading up. So we resintalled same latest version of jomsocial again on both sites which fixed the backend problems but homepage was still loading very slow and only works when we put memory_limit 1GB in PHP.ini which is very very high. Site doesn't get lots of hits. These 2 actually get less than 500 hits a day however a single homepage load is demanding > 512MB ram :O (somewhere in zone of 732MB says the error message if you reduce it to 512MB in php.ini). there is a php.ini in root which you can play with (may be by using phoca commander). The admin userid and password given in this ticket by us will work on crushontube.com site as well for you to have a look investigate, Try putting site in debug mode from joomla admin and then check the home page (don't worry, we are fine with you investigating it in debug mode). You will see too many queries and name of PHP calls which consume the most time and memory. We just want to understand the cause and happy to fix it if you provide some hints or directions to fix it. We are a leading provide of mobile apps for jomsocial and have been the reason behind many jomsocial subscriptions/sales. Would appreciate your help on this, Cheers - N

Hi Navin,

Yes we have some duplicates queries, but right now we cant get rid them , because its too many..
But anyway we will focus with the queries on members module, because that module make the site slower.. so I only can give you the solution to disable that module, it will help you a bit.

thank you!

Hi Navin,

Would you mind provide me phpmyadmin access, please? we will inspect the slow issue on your site, if you dont mind ;)

thank you!

Hi Dimas,

Phpmyadmin is in "phpmyadmincot" folder in root. You can use phocacommander component from admin panel to navigate files and folders.

You can get the database connection from configuration file.

Thanks!

Hi Navin,

Please provide me the full URL for access it.

thank you!