Avatar

Profile My Little Forum - some suggestions (General)

by Auge ⌂ @, Tuesday, March 21, 2017, 21:08 (243 days ago) @ Milo

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

--
further development of mlf1


Complete thread:

 RSS Feed of thread

powered by my little forum