Slow SQL queries? Topic is solved

Discussion regarding Joomla! 3.x Performance issues.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Locked
Forsh
Joomla! Explorer
Joomla! Explorer
Posts: 351
Joined: Sat Aug 20, 2005 3:05 pm
Location: 1135 N Broadway #213 Denver, CO 80203
Contact:

Slow SQL queries?

Post by Forsh » Sat Jul 28, 2018 9:15 pm

Siteground customer support gave me a list of 10 of my slowest executions that are eating up my CPU cycles. Is there a tool inside of Joomla that can assist with this, like pinpointing which extensions are causing this? There is no suspicious activity, they checked it out for me....

SharkyKZ
Joomla! Hero
Joomla! Hero
Posts: 2866
Joined: Fri Jul 05, 2013 10:35 am
Location: Parts Unknown

Re: Slow SQL queries?

Post by SharkyKZ » Sun Jul 29, 2018 9:40 am

Enable Debug.

Forsh
Joomla! Explorer
Joomla! Explorer
Posts: 351
Joined: Sat Aug 20, 2005 3:05 pm
Location: 1135 N Broadway #213 Denver, CO 80203
Contact:

Re: Slow SQL queries?

Post by Forsh » Sun Jul 29, 2018 7:36 pm

Agh, I just did that and logged into my administrator section can't go anywhere. To turn debugging off, is that in configuration.php?

SharkyKZ
Joomla! Hero
Joomla! Hero
Posts: 2866
Joined: Fri Jul 05, 2013 10:35 am
Location: Parts Unknown

Re: Slow SQL queries?

Post by SharkyKZ » Mon Jul 30, 2018 5:28 am

Yes, you can disable debug in configuration.php. Are you getting an error with it enabled?

Forsh
Joomla! Explorer
Joomla! Explorer
Posts: 351
Joined: Sat Aug 20, 2005 3:05 pm
Location: 1135 N Broadway #213 Denver, CO 80203
Contact:

Re: Slow SQL queries?

Post by Forsh » Mon Jul 30, 2018 4:28 pm

SharkyKZ wrote:
Mon Jul 30, 2018 5:28 am
Yes, you can disable debug in configuration.php. Are you getting an error with it enabled?
Yep, site won't load with debug turned on but I did go into the config and changed it to 0 like you recommended, so at least that is fixed up. I

SharkyKZ
Joomla! Hero
Joomla! Hero
Posts: 2866
Joined: Fri Jul 05, 2013 10:35 am
Location: Parts Unknown

Re: Slow SQL queries?

Post by SharkyKZ » Mon Jul 30, 2018 4:38 pm

Enable error reporting when debug is enabled to see why it's not working.


Locked

Return to “Performance - Joomla! 3.x”