PDA

View Full Version : Index quesitions


ImportPassion
03-20-2003, 09:52 PM
In the template table there is a multiple index on title and templatesetid
when i run /forums/index.php?s=&showqueries=1&explain=1
it tells me "possible_keys - title"

Does this mean i should put a separate index just on title?

THanks,
Derek

filburt1
03-20-2003, 09:54 PM
Turn off debug mode while you're at it because you just found a security hole in your forums.

ImportPassion
03-20-2003, 09:58 PM
i sort of need it while i am debugging. what does this have to do with my question?

Xenon
03-20-2003, 09:58 PM
to answer the question: no that's not meant :)

but filburt is right, deactivate the debugmode on your board as it's a security risk.

ImportPassion
03-20-2003, 09:59 PM
what does it mean then?

Xenon
03-20-2003, 10:01 PM
from what i know it means the possible key to use would be title, the col next to it says which was used, it's the same key :)

but i don't know 100% sure :)