I have about 5000 songs in my database so far. As before, I need to add tracks by ID to the TracksWindow. Using AddTracksFromQuery() is around 10 times slower than a way I have found which is rather kludgy (so I would prefer replaced) but is lightning quick - this is basically what happens:No, SDB.MainTracksWindow.AddTracksFromQuery() is the fastest way to add tracks to the main window, as long as you don't have slow SQL's.
When Mediamonkey boots up, I copy each SongData object for all tracks to an Objects array thusly:
Code: Select all
Set it = SDB.Database.QuerySongs("id > 0")
Do While Not it.EOF
SDB.Objects(it.Item.ID) = it.Item ' Copy the SongData object to each Object in the array
it.Next
Loop
This is why my reasoning for allowing the AddTrackById method for SDBTracksWindow would be a great boon. Thousands of ID numbers could be added directly without having to scan the database for each and every ID as with AddTracksFromQuery(). Am I overlooking something?