[thelist] MySQL optimization

Steve Lewis nepolon at worlddomination.net
Tue Sep 27 12:18:17 CDT 2005


Query:
  select DISTINCT sectionid
  from SectionMembers LEFT JOIN Sections ON
      Sections.id=SectionMembers.sectionid
  where Sections.instid = '%bindVal01%'

SectionMembers is an association table joining groups (sections) to 
users (members).  The SectionMembers table has more than 100k rows.

Does anyone see any way to remove the DISTINCT or identify other 
optimizations for this query?

-- 
SteveL



More information about the thelist mailing list