Exclude Staged products from Solr index

[Former Member]

Is there any benefit (e.g. performance) to be had by excluding Staged products from the FlexibleSearch queries which populate the Solr index (and therefore the index itself)? I'm assuming that by default all products are returned from the database, unless there's an exclusion happening I'm not aware of

[Former Member]

Hi ,

Please have a look the following screenshot. you could assign only online catalog in the solrindex.

Best

Nan

[Former Member]

but if you have a very large catalog

[Former Member]

well then its mostly about performance then.

[Former Member]

out of the box there are some filters that limit the results only to the active catalog version so you will see only the results for an active catalog (most likely online). I didn't understand this part "(and therefore index)", because excluding products from solr query is different than from index.

[Former Member]

Sorry - I meant the two queries which update the Solr index, e.g.

 INSERT_UPDATE SolrIndexerQuery;solrIndexedType(identifier)[unique=true];identifier[unique=true];type(code);injectCurrentDate[default=true];injectCurrentTime[default=true];injectLastIndexTime[default=true];query;user(uid)
 ;$solrIndexedType;$searchIndexNamePrefix-fullQuery;full;;;false;"SELECT {PK} FROM {Product}";anonymous

The Update query is a little more complex, and I'm wondering if there's any benefit to be had from excluding Staged products, therefore excluding them from the Solr index itself

[Former Member]

So to be clear this is the FlexibleSearch query which populates the Solr index, not the Solr query which fetches from the Solr index. Is there any benefit/impact from not populating the Solr index with Staged products

[Former Member]

You can also do like this easy way to remove: In catalog version just add online .

e.g: INSERT_UPDATE SolrFacetSearchConfig;name[unique=true];$catalogVersions ;test;$productCatalog:Online