Playlists are currently stored in two tables: - The playlist file together with the playlist title is stored in the "tracks" table - The "tracks" table also contains all the music files - The "playlist_track" table contains the relation between a playlist file and the music file, basically the playlist_track table describes which tracks that are part of a specific playlist.
SqueezeCenter uses a lot of tables when it should play a track, the basic data is in the "tracks" table but it read additional information from "albums" and "contributors" and all the many to many tables to be able to display extra information on the SqueezeBox display. So changing the database structure won't be an easy task independent on how you do it. I would suggest that you continue this discussion in the "Developers" forum, because here in the "General" section it will probably not attract the correct people. The SqueezeCenter source is open source and I suspect that the SqueezeCenter developer would like some real proof of improvement before they change the database structure, especially if the change result in less object oriented and less relational based approach than today. There are also other factors to think about than performance, for example the code has to be easily maintained and that is probably easier today where a specific information is stored in a single table/column in the database. Your suggestion is based on that the data should either be duplicated on multiple rows or even in multiple tables. Before changing the database structure, I also think someone really ought to check what code and database queries that are executed today in the situation where you have performance problem. The solution might be as easy as just optimizing some code or changing a database query a bit. But please continue this discussion in the "Developers" section of the forum. -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and Database Query plugins' (http://wiki.erland.homeip.net/index.php/Category:SlimServer)) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=45261 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
