Hi Vinay, with Elasticsearch enabled, you benefit from a general search performance improvement, even compared with JSONB.
JSONB support will be anyway beneficial for create, reads and updates. Hope this clarifies. Regards. P.S. please send your questions to user@ ML On 2022/03/17 23:19:48 Vinay Kavala wrote: > Thanks Andrea for the clarification! > > However, if we intend to use ElasticsearchAnySearchDAO for searching Users, > Groups and AnyObjects, what is the advantage of enabling JSONB? Where will it > improve the performance of the system? > Can you clarify please? > > Thanks, > Vinay > ________________________________ > From: Andrea Patricelli <andreapatrice...@apache.org> > Sent: Thursday, March 17, 2022 11:30 AM > To: dev@syncope.apache.org <dev@syncope.apache.org>; Vinay Kavala > <vinay.kav...@govaris.com> > Subject: Re: What should be the value of any.search.dao property in. the > persistence.properties > > [CAUTION: EXTERNAL SENDER] > > > Hi Vinay, > > You should anyway use this > > any.search.dao=org.apache.syncope.core.persistence.jpa.dao.ElasticsearchAnySearchDAO > > since queries are performed on ES, in order to have the best > performances while searching. > > On the other end, if you set to PGJPAJSONAnySearchDAO, instead, you're > just telling to Syncope not to use ES to perform searches, but go > directly on db through JSON-based queries, anyway faster than the basic > queries. > > Best regards, > Andrea > > On 14/03/22 18:49, Vinay Kavala wrote: > > Hi Team, > > > > I have enabled Elastic Search on my local syncope instance and it was > > working fine with the prescribed changes. Now I am planning to implement > > JSONB usage as well and am following the documentation provided in the > > syncope docs > > athttps://syncope.apache.org/docs/2.1/reference-guide.html#postgresql-jsonb > > > > > > I have a question now for the any.search.dao property in. the > > persistence.properties file what should be the value of it? > > > > > > #any.search.dao=org.apache.syncope.core.persistence.jpa.dao.ElasticsearchAnySearchDAO > > any.search.dao=org.apache.syncope.core.persistence.jpa.dao.PGJPAJSONAnySearchDAO > > > > > > I currently commented out the ElasticSearchDao entry and enabled the > > JSONAnySearchDAO. Is this correct? or what should be the value for it? > > > > I am seeing few issues in my local when I start up the server, not sure if > > it is related to the same.. just wanted to confirm what is the correct > > value for it. > > > > Thanks, > > Vinay > > > > > -- > Andrea Patricelli > > Tirasa - Open Source Excellence > http://www.tirasa.net/ > > Member at The Apache Software Foundation > Syncope > >