Improve auto index speed times by running queries for each batch rather than each file
I have a local data connection setup with my ERP software, and auto index figured on a file cabinet. We are running into weird errors where auto index is failing to run and I recently discovered that auto index runs the query for each file rather than by batch.
I'm seeing query times upwards of 7 seconds per file. If we store in this particular file cabinet 100 files at a time, it would take 12 minutes to process all that data. However, it could only take as little as 7 seconds to run the query once and assign all data.