Print Page - Speed admin access

Title: Speed admin access
Post by: tidus93 on June 25, 2009, 05:44:35 AM

Hello,

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

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

Title: Re: Speed admin access
Post by: tidus93 on July 01, 2009, 05:10:50 AM

Ok that is what I thought.
Thanks ;)

Simple Machines Community Forum