• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Library sync VERY slow
#2
At the beginning of the sync, a couple of things happen:

1) MobileSheets goes through and reads out all of the data for every song in the entire library. This just means pulling a large amount of data out of the database with various queries.
2) For every file in every song, MobileSheets checks the hash stored in the database as well as the last modified timestamp. If the last modified timestamp stored in the database does not match the last modified timestamp of the file on disk, or if the hash code is 0, the hash is recalculated and the database is updated with the new timestamp. Calculating the hashes for thousands of files can take quite some time, but this would only be necessary if the timestamps for every file did not match up for some reason, or if no previous hashes were stored in the database. I should note that both PDFs and audio files are checked in this manner.

Is something causing the last modified timestamps of all your files to change? Are you making modifications outside MobileSheets? Also, in general, I would not recommend using a two-way sync as it doesn't properly handle deletions (if you delete something on one device, then do a two-way sync, it will be recreated as it sees that one device has something that the other does not). So try to make changes on one device at a time and use a one-way sync.

I have synchronized libraries that are many gigabytes in size, and the whole process took around 15-30 seconds over WiFi if there are no significant changes to process. It definitely should not be taking you 60 minutes every time. Also, if you complete the sync, then just turn around and sync again immediately, does it take the same amount of time or does it finish very quickly?

Mike
Reply


Messages In This Thread
Library sync VERY slow - by TKW - 05-23-2024, 02:11 AM
RE: Library sync VERY slow - by Zubersoft - 05-23-2024, 03:01 AM
RE: Library sync VERY slow - by mdavej - 05-23-2024, 04:34 AM
RE: Library sync VERY slow - by Zubersoft - 05-23-2024, 08:44 AM
RE: Library sync VERY slow - by TKW - 05-25-2024, 04:36 AM
RE: Library sync VERY slow - by Zubersoft - 05-25-2024, 08:26 AM
RE: Library sync VERY slow - by TKW - 05-25-2024, 04:59 PM
RE: Library sync VERY slow - by TKW - 05-25-2024, 11:07 PM
RE: Library sync VERY slow - by Zubersoft - 05-26-2024, 02:05 AM
RE: Library sync VERY slow - by TKW - 05-30-2024, 01:17 AM
RE: Library sync VERY slow - by TKW - 05-30-2024, 03:11 AM
RE: Library sync VERY slow - by Zubersoft - 05-30-2024, 02:26 PM
RE: Library sync VERY slow - by TKW - 05-30-2024, 11:26 PM
RE: Library sync VERY slow - by TKW - Yesterday, 12:51 AM
RE: Library sync VERY slow - by Zubersoft - Yesterday, 09:45 AM



Users browsing this thread:
13 Guest(s)


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