[ 
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)

Reply via email to