Support Article
Process to extract a value from BLOB to a column is slow
SA-56830
Summary
The process to extract a value from BLOB to a column is slow. The table count is 4.7 million and the process does not even run 1000 rows/hr.
Error Messages
Not Applicable.
Steps to Reproduce
Run the shell script.
Root Cause
The amount of data extracted is around 4.7 million records and the process is running on a single thread.
Resolution
Perform the following local-change:- Navigate to prpcUtils.properties
- Set the 'expose.numOfThreads' property value to a higher value in case of updating large sets of data
Published July 23, 2018 - 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.