AND ge.namesearch IN ('ALTERNATIVE ROCK','ART ROCK','BLUES ROCK','DEAD','ELECTRONICA','FOLK JAZZ','FUNK','FUNK R B','FUNK SOUL','FUSION','GRUNGE','HENDRIX','INDIE','JAZZ FOLK','JAZZ FUNK','JAZZ FUSION','JAZZ ROCK','LATIN ROCK','NEW WAVE','PROGRESSIVE METAL','PROGRESSIVE ROCK','PUNK ROCK','R B','R B FUNK','R B SOUL','ROCK','SOUL','SOUL FUNK','SOUL R B','TRIP HOP')
AND ge.id IN (SELECT x.id from genres x where x.namesearch IN ('ALTERNATIVE ROCK','ART ROCK','BLUES ROCK','DEAD','ELECTRONICA','FOLK JAZZ','FUNK','FUNK R B','FUNK SOUL','FUSION','GRUNGE','HENDRIX','INDIE','JAZZ FOLK','JAZZ FUNK','JAZZ FUSION','JAZZ ROCK','LATIN ROCK','NEW WAVE','PROGRESSIVE METAL','PROGRESSIVE ROCK','PUNK ROCK','R B','R B FUNK','R B SOUL','ROCK','SOUL','SOUL FUNK','SOUL R B','TRIP HOP'))
Did you time the duration these two need? In my limited testing with a much smaller collection the second version seemed to be a tiny little bit faster.
-- Michael _______________________________________________ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta