CSC: Product Search is Taking More Time in Product Listing Page When There Are Numerous Records (Doc ID 2245133.1)

Last updated on MARCH 31, 2017

Applies to:

Oracle Commerce Service Center - Version 11.2 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
CSC: product search is taking more time in product listing page when there are more records.

On the product listing page, the CSC application is taking considerable time to display results when searched specially with product descriptions.

The application is not using Endeca with the CSC; it is using the CSC default SQL.

EXPECTED BEHAVIOR
-----------------------
Product search in the CSC with product description should take less time on the product listing page when more records are present, if CSC is used with default SQL.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in to CSC
2. Go to Products tab Select Product Catalog.
3. In the search tab add product description and click on search icon.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, product search with product description in CSC for a large number of records is slow.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms