News:

Wondering if this will always be free?  See why free is better.

Main Menu

Missing indexes

Started by Angelo, April 28, 2009, 12:12:44 PM

Previous topic - Next topic

Angelo


The stats are showing a lot of slow queries.  I must be missing indexes on some tables. Anyone know of a reference for which columns should be indexed for SMF's database?

Aleksi "Lex" Kilpinen

Hi there,

What version are you on for starters? ;)
Could you post a link to your status.php and phpinfo.php?
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

Advertisement: