National Flags

Improve performance - National Flags

Improve performance

by kasimi » Sat Oct 13, 2018 10:07 am

I ran this query on a board with ~30k users and it cut down query time on the index page from 0.14s to 0.001s.

Code: Select all

ALTER TABLE phpbb_users ADD INDEX usrflg (user_flag);
User avatar
kasimi
Former Team Member
Posts: 4900
Joined: Sat Sep 10, 2011 7:12 pm
Location: Germany

Re: Improve performance

by RMcGirr83 » Wed Jul 01, 2020 2:25 pm

Added to 2.1.8
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then you can support me by buying a beer 🍺
User avatar
RMcGirr83
Former Team Member
Posts: 22099
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr