FSQ or SearchQuery SOLR

[former_member624984]

Hi, What is a better approach in terms of reducing performance page load time for fetching product data? Is it using FSQ or SearchQuery using solr indexing?

[Former Member]

To amplify what said, this question is too vague to provide clear imperative answers. Category pages or PDPs or cart pages or ImpEx: each has its own load characteristics. Each will require different efforts to improve performance.

Asking what to do before completely understanding the problem will lead to counterproductive effort.

• Establish NFR performance goals.

• Do a thorough performance analysis including code profiling.

• Determine what the actual performance to NFR goal gap is.

• Determine which components and operations are responsible for the largest fraction of that performance gap.

• Ask about that component with that use case if the solution does not appear obvious.

[arvind-kumar_avinash]

I believe you are already aware that FSQs are cached. So, as long as your data model has been designed meticulously and your FSQs have been optimized, I do not think you will run into any performance problem. You can check the following links for some tips on performance:

• https://help.hybris.com/1811/hcd/8c72d89f866910148f3cdde41bec5ae9.html

• https://help.hybris.com/1811/hcd/8c2780e686691014a134cc8fd1091aa3.html

Please note that your PDP loads the data using FSQs only; Solr just returns the indexed data. It's like the index at the end of a book which tells you where (which page) you will find the details of a particular term from this index. You can compare the book index with the Solr index and the page of the book with PDP.