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.
Post Reply
Forsh
Joomla! Explorer
Joomla! Explorer
Posts: 282
Joined: Sat Aug 20, 2005 3:05 pm
Location: 2029 Larimer St, Denver, CO 80205
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....
Denver Donate, Field Guide for the Homeless & Working Poor https://www.denverdonate.com

 
SharkyKZ
Joomla! Ace
Joomla! Ace
Posts: 1668
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: 282
Joined: Sat Aug 20, 2005 3:05 pm
Location: 2029 Larimer St, Denver, CO 80205
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?
Denver Donate, Field Guide for the Homeless & Working Poor https://www.denverdonate.com

SharkyKZ
Joomla! Ace
Joomla! Ace
Posts: 1668
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: 282
Joined: Sat Aug 20, 2005 3:05 pm
Location: 2029 Larimer St, Denver, CO 80205
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
Denver Donate, Field Guide for the Homeless & Working Poor https://www.denverdonate.com

SharkyKZ
Joomla! Ace
Joomla! Ace
Posts: 1668
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.

 

Post Reply

Return to “Performance - Joomla! 3.x”