Support Article
BIX Job is taking much longer time
SA-8605
Summary
Slowness observed during BIX extraction.
Error Messages
Not Applicable.
Steps to Reproduce
Run the BIX extract daily, slowness observed when DB records are increasing over period.
Root Cause
The root cause of this problem is defect/misconfiguration in the operating environment.
Analyzed three days extraction data for Elapsed Time, Instances per second , Total Records. The increase in the number of records in the database causes the slowness.
RESOLUTION
This issue is resolved through the following local-change:
To improve performance, increase number of records would increase the SQL query execution time:
- Use incremental BIX extracts rather than extracting the entire set of records every time, this reduces the amount of load on the server.
- Add indexes to WO table as to COUNT the records in DB is taking >5 minutes.
- Use Purge/Archive wizard to archive the records which are not required in DB.
Published June 12, 2015 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.