I upgraded from 4.1 to 4.2 SP 14. I see that the jobs are performing very poorly because of Cache spec issue. There are multiple jobs that used pre load cache in 4.1 and was working without any problems. But the same jobs (the source and target db are the same) are performing very poorly in 4.2. In some instances when I change to no_cache it seems to work much better. But I have a job flow where there is a lookup against the target (where the data will be inserted or updated at the end of the flow) table (millions of rows). When I use no_cache it seems to lock the table.
The questions I have is
- what is changed in cache spec from 4.1 to 4.2
-What is the best practice to lookup keys before inserting into the target table.
Thank you for your time.