Which version of Access Analyzer do you have?
Access Analyzer 12.0
What is a one sentence summary of your feature request?
Request optimization of the SA_FSAA_LookupResourcePath function, specifically to address performance bottlenecks and table blocking caused by the If-Else logic loop during the DropFSHostData job execution.
Please describe your idea in detail. What is your problem, why do you feel this idea is the best solution, etc.
The DropFSHostData job triggers the built-in function SA_FSAA_LookupResourcePath. The core performance issue appears to stem from the If-Else structure within the function, which introduces a loop that is inefficient under load or with current data volumes.
Optimizing this specific logic (If-Else/Loop) is considered the best solution because it directly targets the root cause identified during the incident, rather than applying workarounds or increasing server resources. This should prevent the blocking behavior while preserving the core functionality of the job.
How do you currently solve the challenges you have by not having this feature?
There’s no solution currently, since it’s an optimization request.