erland wrote: > Hopefully someone will take the time to update TrackStat so it creates > the indexes by itself. > Would certainly be a better solution.
> The intention is that TrackStat should already today create some of the > single column indexes but maybe that doesnÂt work since you have them > in your plugin ? I've been using TrackStat for a long time, and quite a while ago (years) I noticed that some of the default indices were missing - no idea why. Back then, I also added some other indices. Since I was writing this plugin anyway, I decided to include them - since I use 'IF NOT EXISTS', existing ones won't be affected. > > As itÂs done now I think the indexes will be duplicated since you use > different index names, duplicate indexes might decrease write > performance. Which indices do you mean? The ones taken from TrackStat should use the same names afaik. > The index in tracks table should probably be added to LMS code instead > of having it as a plugin. The reason TrackStat creates an index in > tracks table is just because it was harder to convince/get core > developer to do additions to the core 15 years ago, should be easier > today when LMS development is driven by community. I guess Michael would be the person to assess which index is of general benefit. > Have you performed any tests to see which TrackStat operations that are > improved ? > Back then, I probably did, but that was a couple of years ago, so I'm rather hazy on the details. > Having them in your plugin as a first step could be a good idea to > verify how much improvement it results Generally, maybe, but since the plugin's main purpose is to change various DB parameters, so it'll be difficult to isolate specifics. 'Various SW' (https://www.nexus0.net/pub/sw/): Web Interface | TUI | Playlist Editor / Generator | Music Classification | Similar Music | Announce | EventTrigger | Chiptunes | LMSlib2go | ... 'Various HowTos' (https://www.nexus0.net/pub/documents/LMS/): build a self-contained LMS | Bluetooth/ALSA | Control LMS with any device | ... ------------------------------------------------------------------------ Roland0's Profile: http://forums.slimdevices.com/member.php?userid=56808 View this thread: http://forums.slimdevices.com/showthread.php?t=114067
_______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
