Hopefully someone will take the time to update TrackStat so it creates
the indexes by itself. The intention is that TrackStat should already
today create some of the single column indexes but maybe that doesnt
work since you have them in your plugin ? As its done now I think the
indexes will be duplicated since you use different index names,
duplicate indexes might decrease write performance.
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.
Have you performed any tests to see which TrackStat operations that are
improved ?
Having them in your plugin as a first step could be a good idea to
verify how much improvement it results in, so Im not criticizing your
work just mentioning the above since I think its the next step to take.
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
Developer of 'many plugins/applets'
(https://wiki.slimdevices.com/index.php/User_Erland.html)
*Starting with LMS 8.0 I no longer support my plugins/applets* ('see
here for more information'
(https://forums.slimdevices.com/showthread.php?49483-Announce-New-versions-of-erlands-plugins&p=998836&viewfull=1#post998836)
)
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=114067
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
