Guide to Optimizing Large Endeca Queries in an Oracle Commerce ATG+Endeca Integrated Application
(Doc ID 1952913.1)
Last updated on DECEMBER 06, 2019
Oracle Commerce Platform - Version 9.4 and later Oracle Commerce Guided Search / Oracle Commerce Experience Manager - Version 3.1.0 and later Information in this document applies to any platform.
Based on experience with customers, we've seen some recurring patterns with applications making one-off queries to Endeca. It can be easy to make a query to Endeca that is slow and/or huge. This can have performance implications.
This document is based on results from performance tuning exercises.
By using some of the rules listed in this document, customers can optimize a lot of Endeca queries (in an ATG + Endeca application) turning a 1, 5 or even 15 megabyte responses into a much smaller 10-100kb responses (thus saving the JVM from excessive memory churn and garbage collection within ATG).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!