Customizing SMF > Modifications and Packages
Allow select multiple boards for message icons
Arantor:
No, really, there is.
There are old techniques that are used because back when they were used, things were different. Except that now, some years later, better techniques are used.
The technique you're suggesting is much the same as how SMF stores what groups can see what boards, amongst other things. Except that it's one of the performance hurting aspects of the DB design because it's slow to search through (and this would require a search)
Jade Elizabeth:
How would board icons require a search?
Arantor:
Under your proposal it would have to apply a search to find the list of icons valid for a given board. This is distinctly not efficient (and would have to be specially rewritten for PostgreSQL and SQLite too, as it happens)
Jade Elizabeth:
Then do the reverse and have it save by board, not icon. Then the search only happens in admin.
Arantor:
And posting.
There's still an overhead involved in finding the board's icons and then splitting it out, an overhead that doesn't necessarily apply by not using a technique that's outdated and horribly inefficient and instead using MySQL the way it was designed to be used.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version