You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@syncope.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2025/01/21 12:50:00 UTC

[jira] [Commented] (SYNCOPE-1855) Refactor database search to use less nested queries

    [ https://issues.apache.org/jira/browse/SYNCOPE-1855?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17914971#comment-17914971 ] 

ASF subversion and git services commented on SYNCOPE-1855:
----------------------------------------------------------

Commit db24b633e9cb33d4fb2b1c82497942de3e1314a4 in syncope's branch refs/heads/3_0_X from Francesco Chicchiriccò
[ https://gitbox.apache.org/repos/asf?p=syncope.git;h=db24b633e9 ]

[SYNCOPE-1855] Rewriting JPAAnySearchDAO to reduce subqueries (#957)



> Refactor database search to use less nested queries
> ---------------------------------------------------
>
>                 Key: SYNCOPE-1855
>                 URL: https://issues.apache.org/jira/browse/SYNCOPE-1855
>             Project: Syncope
>          Issue Type: Improvement
>          Components: core
>            Reporter: Francesco Chicchiriccò
>            Assignee: Francesco Chicchiriccò
>            Priority: Major
>             Fix For: 3.0.11, 4.0.0
>
>
> The current implementations of the database search feature, unless maybe {{pgjsonb}}, seem to be generating SQL statements always containing nested queries, which could instead be avoided most of the time.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)