Speed admin access

[tidus93]

Hello,

I just want to know if it's possible to speed this query which is used to show administrator list in admin panel:

Code Select Expand

SELECT ID_MEMBER, realName
      FROM smf_members
      WHERE ID_GROUP = 1 OR FIND_IN_SET(1, additionalGroups)
      LIMIT 33

Indeed, with 1 000 000 members, it needs 9 seconds to show admin panel.
Thanks

[tidus93]

Ok that is what I thought.
Thanks