Skip to main content
2 votes

Is this PL/SQL Stored proc optimal?

As mentioned, consider MERGE to handle the conditional INSERT and UPDATE actions. Doing so, ...
Parfait's user avatar
  • 960
1 vote

Spring Batch Item Writer Calling Stored Procedure

Is there any approach to enhance the performance for processing 17,000 records, which currently takes approximately 21 minutes? So app level throughput is less than 14 row/second. Yikes! Achieving ...
J_H's user avatar
  • 29.2k

Only top scored, non community-wiki answers of a minimum length are eligible