• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Quick links
#8
@Oz Cello

I don't really understand what you are doing but it sounds as though you have 3000 odd songs in your backup (possibly 12000 if there is a different version for the 4 instruments).
Each tablet is given the full backup and you then delete the unwanted songs/parts.

This means that you are deleting 3/4 of the entries each time. Processing long lists on a pc is time consuming and it also depends on how the deletion process has been coded. Typically, coders process the list from first to last because that is the way we would do it manually) whereas the quickest way on a pc is to do it from last to first (this minimises any shuffling of records because you only shuffle the records you want to retain). Note: I've no ideas how Mike codes it.

You also talk about deleting the songs; this implies that you are deleting physical files. Again, a long process when there are many files. I suspect your tablet stores the files in alphabetical order so performance also suffers if files are deleted from first to last. In this case, it is worse than deleting from the database as each file involves one or more calls to the filing system with a "shuffle" after each deletion  (that is a lot of shuffling)

What can be done about it?

If Mike is deleting from first to last, he should consider deleting from last to first.

If you are deleting the songs then you should try to experiment with removing them instead e.g. one delete songs from the main Songs tab but one can remove songs from a collection or setlist (removing would eliminate the time spent performing physical file deletions).
Note: I've no idea whether this will work with your way of synchronising the different instruments; it is just something that may help you improve the operation.

One other way you could consider is to use a separate library per instrument (I know it breaks your one backup goal) and store these in the cloud. Each tablet could then sync to it's instrument of choice. As someone who manages the database, this would involve more work in switching between libraries, backing them up separately and ensuring that the song metadata was consistent across the libraries.

I hope the above helps.
Stay safe
Geoff
Samsung Galaxy Tab A6
Reply


Messages In This Thread
Quick links - by Oz Cello - 09-11-2020, 10:42 AM
RE: Quick links - by DonC - 09-11-2020, 08:46 PM
RE: Quick links - by Zubersoft - 09-12-2020, 04:19 AM
RE: Quick links - by Oz Cello - 09-12-2020, 11:48 AM
RE: Quick links - by Oz Cello - 10-01-2020, 06:02 PM
RE: Quick links - by BRX - 10-01-2020, 06:10 PM
RE: Quick links - by Oz Cello - 10-02-2020, 02:47 PM
RE: Quick links - by Geoff Bacon - 10-02-2020, 05:55 PM
RE: Quick links - by BRX - 10-02-2020, 08:38 PM
RE: Quick links - by Oz Cello - 10-02-2020, 11:02 PM
RE: Quick links - by BRX - 10-02-2020, 11:51 PM
RE: Quick links - by Zubersoft - 10-03-2020, 05:18 AM
RE: Quick links - by Oz Cello - 10-03-2020, 10:06 AM
RE: Quick links - by Zubersoft - 10-03-2020, 10:29 AM
RE: Quick links - by Oz Cello - 10-03-2020, 11:33 AM
RE: Quick links - by Oz Cello - 10-05-2020, 10:09 AM



Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2024 MyBB Group.