Seach using DB

cancel
Showing results for 
Search instead for 
Did you mean: 
ranjeetsi
Established Member II

Seach using DB

Hi alfresco community,

I am using Alfresco contnet Services 6.2.2 .

Would like to use DB to search contnet& properties and not solr6 .Can you please let me know what settings i can do to test it. 

Appreciate responses on it.

regards,

Ranjeet

p.s -  We don't have Full text search requirement

Alfresco Content Services Certified Engineer (ACSCE)
2 Replies
abhinavmishra14
Advanced

Re: Seach using DB

AFAIK, you can only make use of TMDQ in this case. Also not every query would be supported. 

Refer the documentation here:

https://docs.alfresco.com/search-services/latest/using/ 

https://docs.alfresco.com/search-services/latest/config/transactional/ 

https://hub.alfresco.com/t5/alfresco-content-services-blog/transactional-metadata-query-tmdq/ba-p/28... 

You would have to set the following property as:

solr.query.cmis.queryConsistency=TRANSACTIONAL

same for fts if needed. 

Also consider performance scenarios before taking this approach to production. 

 

~Abhinav
(ACSCE, AWS SAA, Azure Admin)
ranjeetsi
Established Member II

Re: Seach using DB

 Hi @abhinavmishra14 ,

 

Thanks for your reply - Actually i have already tried that but after making the changes the search doesn't work.

Not able to get search results post the changes.

regards,

Ranjeet

Alfresco Content Services Certified Engineer (ACSCE)