Search Cache Is Bypassed For Query That Returns No Results
Last updated on FEBRUARY 06, 2018
Applies to:Oracle WebCenter Content - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
If you run a query using GET_SEARCH_RESULTS that returns no results it skips the search cache and still makes the database calls the second time you run the query. This causes an unnecessary performance hit. Steps to show behavior:
1. Turn on the searchcahe, searchquery, systemdatabase trace sections with verbose output
2. Run a query you know returns no results, e.g. dDocName `1234`
3. Run the query again
4. check the trace output, you will see that the second time you ran the query it went back to the database again, even when it says it found the query in the cache.
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