2013-08-06, 08:08
Updating the database with a large number of pictures is mind-numbingly slow especially if there are only a handful of pictures that are new or updated. If i'm not mistaken, and please correct me if I am, the script is walking through each path and checking each picture to determine which files are new or have been modified to update or insert into the database.
Have you given much consideration to implementing a "quick scan" feature that uses the parent folder modification date instead? The parent folder modification date should reflect any child files that have been modified. This would quickly rule out unnecessary image scans in folders that have not been modified since the last scan and speed up the scan significantly.
Have you given much consideration to implementing a "quick scan" feature that uses the parent folder modification date instead? The parent folder modification date should reflect any child files that have been modified. This would quickly rule out unnecessary image scans in folders that have not been modified since the last scan and speed up the scan significantly.
