Re: Performance improvements: SQL queries

2019-10-09 Thread Francesco Chicchiriccò
Hi Dmitriy, thanks for your analysis. Please consider that: 1. you should refer to latest Syncope 2.1 (2.1.5 at the moment), rather than old 2.0.12. 2. the queries are generated in the current form because of the various use cases they need to work for, and that are mostly checked by various

Performance improvements: SQL queries

2019-10-09 Thread Dmitriy Brashevets
Hi Apache Syncope team! Currently, we're using the Apache Syncope 2.0.12 version. AS provides the wide rest API and our team would like to have the org.apache.syncope.common.rest.api.service.AnyService#search working faster as we do the search of groups and users using FIQL queries. Here is