[
http://www.jahia.org/jira/browse/JAHIA-2146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Benjamin Papez resolved JAHIA-2146.
-----------------------------------
Resolution: Fixed
This one has been fixed already
> Performance improvements to ContainerFactory.doContainerFilterSearchSort
> ------------------------------------------------------------------------
>
> Key: JAHIA-2146
> URL: http://www.jahia.org/jira/browse/JAHIA-2146
> Project: Jahia Content Management Server
> Issue Type: Improvement
> Components: Filtering, Sorting and Splitting Features
> Reporter: Benjamin Papez
> Assignee: Khue N'Guyen
> Fix For: 5.0 SP3
>
>
> In Jahia 4.2 Khue added a "sort container list ranking when no container
> sorter defined". This feature has not been ported to Jahia 5 yet.
> There are issues (e.g. PEU-58 are MAN-15) with the current implementation of
> the SELECT, as it could return duplicate container IDs. So one suggestion
> (PEU-58) is to use
> SELECT id_jahia_ctn_entries, rank_jahia_ctn_entries FROM jahia_ctn_entries
> GROUP BY id_jahia_ctn_entries ORDER BY min(rank_jahia_ctn_entries)
> Furthermore we should think about optimizing the performance as very often
> only the result is just one container and then we go to select ALL container
> IDs (sorted by rank), what is a lengthy process and we just remove all of
> them and return one ID. In that case a select would be totally unnecessary.
> Even if just a handful of container IDs are in the result, it would be better
> to add them to the WHERE clause of the SELECT.
> So we would need to extend the BitSet class a bit to give us more flexibility.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://www.jahia.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
jira_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/jira_list
