topic Re: alfresco 5.1 metadata search in Alfresco Forum

alfresco 5.1 metadata search

ecmuser20 — Thu, 16 Feb 2017 21:58:34 GMT

Hello All,I am going to use Alfresco 5.1.2 and want to check if I want to search metadata only, do I still need to have solr enabled or can metadata search be performed without enabling solr.

Re: alfresco 5.1 metadata search

jpotts — Thu, 16 Feb 2017 22:38:44 GMT

You can run without solr, but you won't be happy with the performance.

Why would you want to do that?

Re: alfresco 5.1 metadata search

ecmuser20 — Fri, 17 Feb 2017 00:18:34 GMT

We want to test without solr..for this option we need to disable solr after initial install ? If we want content search then solr need to be enabled ? Is our understanding correct ?

Thanks.

Re: alfresco 5.1 metadata search

afaust — Fri, 17 Feb 2017 01:14:47 GMT

For any searches that need to use some kind of keyword search, fuzzy/partial text matching via tokensiation/stemming, case insensitive comparison, range checks, date/time checks, content full text search.... you need SOLR. Metadata search against the DB only supports a small subset of the Alfresco search capabilities and queries need to be specifically written to be supported (most query examples you find on the net typically don't support it).

I have to correct Jeff in a small detail: metadata queries against the DB can be very fast and even faster than SOLR queries (with their HTTP overhead), but you need the right use case, content model and a reasonably well managed / maintained database (statistics; query plan reoptimisation enabled; ideally even some custom indices for common DB search use cases). But due to spotty / non-existent documentation on the criteria for "suitable use cases" / "good performance", most people do end up not being happy with the performance...

Also, if you just want to test without SOLR you do not need to disable / stop it. Simply set your default query consistency to TRANSACTIONAL and SOLR will not be called for any searches unless code specifically allows it to be by overriding the default setting.

Re: alfresco 5.1 metadata search

jpotts — Fri, 17 Feb 2017 01:49:16 GMT

Yes.