Bad performance with Get Transaction List REST API (Doc ID 2886687.1)

Last updated on MARCH 06, 2023

Applies to:

Symptoms

Slow performance while running a Get Transaction List REST API with query q={$and:[{attribute:'value'}]}

https://sitename.bigmachines.com/rest/v14/commerceDocumentsOraclecpqoTransaction?fields=field1,field2,...field_n&q={$and:[{attribute:'value'}]}&orderby=attribute=50&offset=0

Expected Behavior:
=================
The response time should be less than a second or close to a second.

Current Behavior:
=================
Takes more than 35 seconds to get the Response.

Business Impact:
===============
Performance issues with REST API calls.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.