[
https://issues.apache.org/jira/browse/SYNCOPE-1006?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Francesco Chicchiriccò closed SYNCOPE-1006.
-------------------------------------------
Resolution: Won't Fix
> Performance and NoSql database support
> --------------------------------------
>
> Key: SYNCOPE-1006
> URL: https://issues.apache.org/jira/browse/SYNCOPE-1006
> Project: Syncope
> Issue Type: Improvement
> Reporter: Laszlo Miklosik
> Priority: Major
> Labels: Improvement
>
> CRUD via the API and especially the search are very slow when you have e.g.
> 400.000 users with 30-40 normal attributes in place.
> JPA and relational databases are not the optimal solution for the performance
> sensitive problem of provisioning and Syncope's search query builder is a
> very complex/fragile piece of code.
> I am using Syncope 1.1.5 at the moment but I expect no miracles from 1.2.10
> or 2.x with this amount of users and the same persistence solution.
> I am raising this ticket because I did not find performance related items
> planned in the Syncope roadmap.
> - Do you consider switching the persistence layer to a document store (e.g.
> MongoDB)? I think its schema-less nature would be ideal for storing flexible
> attributes and this way the row/document count explosion problem would be
> avoided by design.
> - Another possible performance improvement would be an async layer for the
> persistence and/or the REST API as well. Maybe using e.g. Redis or other
> publish-subscribe solution for this part?
> Thanks!
--
This message was sent by Atlassian Jira
(v8.20.7#820007)