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