Dear all,
Please lend your precious expertise.
Slow Faceted search query I'm trying to improve performance of the faceted search on my project. For some keywords, it takes more than 20 seconds to return less than 4000 results. And this after starting using Solr. Before that it would incredibly take more than a minute.
2 queries After starting to use Solr, I could see that the Faceted search is sending 2 queries to the Search Engine:
AND
Version information I'm using Liferay 6.2 CE GA2 and Solr 4.10.4 connected via the plugin "Solr 4 Search Engine CE" from the Marketplace.
Eureka moment Applying these queries directly on the Solr administrator panel I discovered that the single parameter "facet.limit=-1" was the cause of making the query take more than a second to be processed. If we remove this parameter on change the -1 value to any number, the query is processed in less than a second.
Questions My questions are:
I'm sure that with your help, this search behavior will become less mysterious to me
.
Thank you and have a great day.
Please lend your precious expertise.
Slow Faceted search query I'm trying to improve performance of the faceted search on my project. For some keywords, it takes more than 20 seconds to return less than 4000 results. And this after starting using Solr. Before that it would incredibly take more than a minute.
2 queries After starting to use Solr, I could see that the Faceted search is sending 2 queries to the Search Engine:
q=%2B(%2B(companyId:10204)+%2B((%2B(entryClassName:com.liferay.portlet.documentlibrary.model.DLFileEntry)+%2B(status:0)+%2B(hidden:false))))+%2B(assetCategoryTitles:chiara*+assetCategoryTitles_en_US:chiara*+assetTagNames:chiara*+title:chiara+description:chiara+content:chiara+expando/custom_fields/space-title:chiara+expando/custom_fields/space-author:chiara*+expando/custom_fields/space-location:chiara*+expando/custom_fields/space-audience:chiara*+expando/custom_fields/space-description:chiara+expando/custom_fields/space-cross-reference:chiara)+%2BcompanyId:10204&rows=0&wt=javabin&version=2AND
f.expando/custom_fields/space-audience.facet.sort=count&hl=true&hl.requireFieldMatch=true&fl=*,score&hl.fragsize=80&f.expando/custom_fields/space-title_en_US_sortable.facet.sort=count&f.expando/custom_fields/space-author.facet.sort=count&hl.simple.pre=<liferay-hl>&f.entryClassName.facet.sort=count&f.groupId.facet.sort=count&f.expando/custom_fields/space-location.facet.sort=count&hl.fl=assetCategoryTitles&hl.fl=assetCategoryTitles_en_US&hl.fl=content&hl.fl=content_en_US&hl.fl=description&hl.fl=description_en_US&hl.fl=title&hl.fl=title_en_US&wt=javabin&facet.field=expando/custom_fields/space-cross-reference&facet.field=modified&facet.field=assetCategoryIds&facet.field=expando/custom_fields/space-date&facet.field=entryClassName&facet.field=expando/custom_fields/space-title_en_US_sortable&facet.field=expando/custom_fields/space-location&facet.field=groupId&facet.field=expando/custom_fields/space-audience&facet.field=expando/custom_fields/space-author&start=0&sort=score+desc&rows=3584&f.modified.facet.sort=count&version=2&hl.snippets=3&facet.limit=-1&q=%2B(%2B(companyId:10204)+%2B((%2B(entryClassName:com.liferay.portlet.documentlibrary.model.DLFileEntry)+%2B(status:0)+%2B(hidden:false))))+%2B(assetCategoryTitles:chiara*+assetCategoryTitles_en_US:chiara*+assetTagNames:chiara*+title:chiara+description:chiara+content:chiara+expando/custom_fields/space-title:chiara+expando/custom_fields/space-author:chiara*+expando/custom_fields/space-location:chiara*+expando/custom_fields/space-audience:chiara*+expando/custom_fields/space-description:chiara+expando/custom_fields/space-cross-reference:chiara)+%2BcompanyId:10204&hl.simple.post=</liferay-hl>&f.expando/custom_fields/space-date.facet.sort=count&f.expando/custom_fields/space-cross-reference.facet.sort=count&f.assetCategoryIds.facet.sort=count&facet=trueVersion information I'm using Liferay 6.2 CE GA2 and Solr 4.10.4 connected via the plugin "Solr 4 Search Engine CE" from the Marketplace.
Eureka moment Applying these queries directly on the Solr administrator panel I discovered that the single parameter "facet.limit=-1" was the cause of making the query take more than a second to be processed. If we remove this parameter on change the -1 value to any number, the query is processed in less than a second.
Questions My questions are:
- How can I change the facet.limit to 1000 or any other number?
- Why does the Faceted Search is creating 2 queries? Is this normal?
I'm sure that with your help, this search behavior will become less mysterious to me
.Thank you and have a great day.