Case Search with Large Results much Slower in CRM 9.2 than in CRM 9.1
Last updated on JANUARY 09, 2017
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.
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