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.
Post Reply
Forsh
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 181
Joined: Sat Aug 20, 2005 3:05 pm
Location: 2029 Larimer Drive Denver, Colorado 80305
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! Ace
Joomla! Ace
Posts: 1335
Joined: Fri Jul 05, 2013 10:35 am
Location: Unknown

Re: Slow SQL queries?

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

Enable Debug.

Forsh
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 181
Joined: Sat Aug 20, 2005 3:05 pm
Location: 2029 Larimer Drive Denver, Colorado 80305
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! Ace
Joomla! Ace
Posts: 1335
Joined: Fri Jul 05, 2013 10:35 am
Location: 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! Enthusiast
Joomla! Enthusiast
Posts: 181
Joined: Sat Aug 20, 2005 3:05 pm
Location: 2029 Larimer Drive Denver, Colorado 80305
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! Ace
Joomla! Ace
Posts: 1335
Joined: Fri Jul 05, 2013 10:35 am
Location: 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”