Please provide insights on the system performance for the below requirement.

Summary:

We currently have around 1,500 price lists, which collectively amount to approximately 1 million pricing records. On average, about 20,000 records are either inserted or updated within these price lists. We would like to understand the system performance implications when handling 1 million records, both for: Sales orders created directly in Oracle Fusion Scenarios where external systems invoke the pricing API via REST. Could you please provide insights on expected performance under this data volume?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):