To speed up "sync record", consider caching the file lists that come back and the date/time we made that call, then append that to the "updated after" query to get just the records that have changed since you last cached it, and then update the cache. This should greatly improve performance in areas like Script Includes, sys_script where there is a very large number of records.
To speed up "sync record", consider caching the file lists that come back and the date/time we made that call, then append that to the "updated after" query to get just the records that have changed since you last cached it, and then update the cache. This should greatly improve performance in areas like Script Includes, sys_script where there is a very large number of records.