Case Search with Large Results much Slower in CRM 9.2 than in CRM 9.1
(Doc ID 2211412.1)
Last updated on FEBRUARY 04, 2019
Applies to:PeopleSoft Enterprise CRM Support - Version 9.2 and later
Information in this document applies to any platform.
Support Case Search that returns 250 rows runs in about 11 seconds in CRM 9.1 while in CRM 9.2 the same search takes almost 3 minutes to complete.
Steps to Reproduce:
1. Make sure Support Case Search is configured to return 250 rows on both CRM 9.1 and 9.2
2. Do a Support Case search on both versions that would return 250 rows
3. The result in CRM 9.1 takes 11 seconds to complete while in CRM 9.2 is almost 3 minutes.
Running the SQL behind the Case Search in the backend for both versions completed in 1 second.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document