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