[
https://jira.duraspace.org/browse/DS-1223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=26136#comment-26136
]
Andrea Bollini commented on DS-1223:
------------------------------------
you can do the same trick also when browsing is scoped to a community or a
collection
the resulting query for a collection should be
SELECT COUNT(*) AS num, distable.value, distable.authority FROM (SELECT
bi_2_dis.* FROM bi_2_dis, (SELECT DISTINCT bi_2_dmap.distinct_id FROM
collection2item,
bi_2_dmap WHERE bi_2_dmap.item_id=collection2item.item_id AND
collection2item.collection_id=? )
mappings WHERE bi_2_dis.id=mappings.distinct_id ORDER BY sort_value ASC NULLS
LAST LIMIT ?) distable,
(SELECT bi_2_dmap.distinct_id FROM bi_2_dmap) mappings WHERE
distable.id=mappings.distinct_id GROUP BY
distable.value, distable.authority, distable.sort_value ORDER BY sort_value ASC
NULLS LAST
in my environment using a "large collection" that include almost all the
content of the repository (4000authors / 8000 items) I see a 25% performance
improvement.
The main point is that with this query the size of the left side of the join is
fixed at the pagination size.
Are you checking also the Oracle side?
> Display frequencies of items in single browsing for selected indices
> --------------------------------------------------------------------
>
> Key: DS-1223
> URL: https://jira.duraspace.org/browse/DS-1223
> Project: DSpace
> Issue Type: Improvement
> Components: JSPUI
> Affects Versions: 1.8.2
> Reporter: Christina Paschou
> Labels: has-patch, has-pull-request
> Attachments: browse_frequencies.diff, README.txt
>
>
> DSpace provides by default two types of browsing, naming them single browsing
> and full browsing according to the corresponding names of the .jsp files that
> are responsible for handling each request (single.jsp & full.jsp).
> Each type of browsing is defined accordingly and configured in different way
> in the configuration file dspace.cfg.
> The proposed improvement is applied for the case of browsing by a unique
> index of metadata values from the item (single browsing). In this case, the
> user can define for each metadata browse index whether he wishes to add next
> to its various metadata values the frequencies of items that are included.
> The configuration takes place in the dspace.cfg.
> Examples:
> http://phdtheses.ekt.gr/eadd/browse?type=subject
> http://phdtheses.ekt.gr/eadd/browse?type=country
> http://phdtheses.ekt.gr/eadd/browse?type=language
> Attached you can find the patch file and a readme file with details about tha
> configuration that is needed to be made.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel
