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
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
