Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => SMF Feedback and Discussion => Aiheen aloitti: L.G.S - helmikuu 17, 2008, 01:09:58 IP

Otsikko: Cutting down the queries
Kirjoitti: L.G.S - helmikuu 17, 2008, 01:09:58 IP
What exactly are they?

How can I find out which queries I have are SMF, and not? I have 58 queries which process in 0.11 seconds, and by looking at other forums thats a load.

Otsikko: Re: Cutting down the queries
Kirjoitti: Gary - helmikuu 17, 2008, 01:25:36 IP
Turn debug mode on.

Add


$db_show_debug = true;


to Settings.php
Otsikko: Re: Cutting down the queries
Kirjoitti: Grudge - helmikuu 17, 2008, 02:01:09 IP
SMF will never use more than about 15-20 queries apart from on certain moderation/admin actions.

Lots of queries aren't necessarily bad (In fact we purposely split some queries into two to improve the speed compared to doing it all in one) but 58 is a hell of a lot - must be mods?
Otsikko: Re: Cutting down the queries
Kirjoitti: vbgamer45 - helmikuu 17, 2008, 02:04:16 IP
Most of those queries are probably going from modifications that were installed to the forum. I noticed you are using Tiny Portal for http://www.ruthlessintent.com/board Depending on the blocks that you add that could cause a large increase in the number of queries
Otsikko: Re: Cutting down the queries
Kirjoitti: L.G.S - helmikuu 17, 2008, 02:14:25 IP
Okay thanks for the tips.

Gonna start removing some of these unused mods ;)