Re: xPLMediaNet various

[Tom Van den Panhuyzen <tomvdp@xxxxxxxxx>]

>
> However, I am thinking that the "media.dll" source should
generate some
> additional reference tables for artist/album/genre lists. This would
make
> displaying the lists much faster for people who have a lot of tracks,
as
> currently these lists are generated are by processing the complete
list of
> tracks?
>
> Obviously this makes the database bigger, but is probably worth it?
>
> Any thoughts/comments please?
>

If all the data for these artist/album/genre lists is already in the
one flat table, it is better to index on the fields that you will make
lists of.

E.g.

select distinct artist_name
from artists

will be efficient if you have indexed artist_name.  In this case there
is no need for a seperate table with only artist_name values.

Hth,
Tom


xPL Links: http://www.xplproject.org.uk http://www.xplhal.com http://www.xpl.myby.co.uk
To Post a Message: ukha_xpl@xxxxxxx
To Subscribe:  ukha_xpl-subscribe@xxxxxxx
To Unsubscribe:  ukha_xpl-unsubscribe@xxxxxxx