Profile My Little Forum - some suggestions (General)
Hello
That's my suggestion.
After reading I think, your suggestion is reasonable. I altered the table structure of my testing installation.
I cannot check the benefit, because I don't have a forum that has so many threads/postings.
"Not so many posts." pfft.
Your forums with a few hundred threads and a few thousand entries is so much more, than I can offer (13 entries in 7 threads).
A further field, which is often used in WHERE
-clauses is the field user_type
from the table mlf_userdata
. Maybe the column user_name
could be indexed too (user lists, search in user area …).
ALTER TABLE `mlf2_userdata` ADD INDEX(`user_type`); ALTER TABLE `mlf2_userdata` ADD INDEX(`user_name`);
Any comments?
Tschö, Auge
--
Trenne niemals Müll, denn er hat nur eine Silbe!