[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