mherger wrote:
> > 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
First one executes in 277 ms.
Second one in 225 ms.
This is running against a copy of a slightly older version of my
library.db
select count (id) from tracks
returns 311,530 rows.
Win7Pro(x64)[3.3Ghz i5, 8GB RAM, 120GB SSD system, 15TB storage], LMS
7.9.0 -> Logitech Squeezebox Classic V.3 -> Cambridge Audio DacMagic ->
NAD C160 -> 2 x NAD C272 -> Quad 22L2
------------------------------------------------------------------------
get.amped's Profile: http://forums.slimdevices.com/member.php?userid=10022
View this thread: http://forums.slimdevices.com/showthread.php?t=101701
_______________________________________________
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta
