Switch between Solr and DB for Query Execution

devkinandanchau — Tue, 23 Oct 2018 12:06:41 GMT

Using Alfresco Community - 5.0.0 version.Tried below properties in alfresco-global.properties file:queryConsistency=EVENTUAL then all queries are going to Solr.queryConsistency=TRANSACTIONAL then all queries are going to DB. And Default mode executes all queries from DB first then Solr in case of fa

Re: Switch between Solr and DB for Query Execution

cesarista — Wed, 24 Oct 2018 10:07:16 GMT

Hi:

I think you refer to the following properties:

solr.query.cmis.queryConsistency

solr.query.fts.queryConsistency

Q1: No, you have three modes TRANSACTIONAL_IF_POSSIBLE (first database, if not SOLR), TRANSACTIONAL (database only), EVENTUAL (solr only).

Q2: In the first mode, you can compare the results of a CMIS query obtained from database, with a solr-based query "introducing" an extra part that makes the query only to be solved with SOLR (for example adding some unsupported predicate for database)

Transactional metadata queries supported by database | Alfresco Documentation

Regards.

--C.

topic Switch between Solr and DB for Query Execution in Alfresco Forum

Switch between Solr and DB for Query Execution

Re: Switch between Solr and DB for Query Execution