The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024

Latest message you have seen: Brt/Dim commands through W800 X-10 receiver


[Message Prev][Message Next][Thread Prev][Thread Next][Message Index][Thread Index]

RE: xPLMediaNet various


  • Subject: RE: xPLMediaNet various
  • From: "Tony Tofts" <tony@xxxxxxxxxx>
  • Date: Fri, 1 Apr 2005 16:12:30 +0100


Hi Tom,

> 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.

They are all indexed, so I'm using for example:

select distinct artist from music order by artist

Not sure it's as fast as a separate table though (in a case with 30000
tracks)

But I'll hold off any changes until I've (and others) have tested the
current setup with more than I currently test with (about 500 tracks)

Thanks
Tony



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

xPL Main Index | xPL Thread Index | xPL Home | Archives Home

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.