Project

General

Profile

Bug #2557

Metacat Performace: Rewrite the xml_access part of the query

Added by Matt Jones about 13 years ago. Updated almost 12 years ago.

Status:
Resolved
Priority:
Immediate
Assignee:
Category:
metacat
Target version:
Start date:
09/28/2006
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
2557

Description

The subpart of metacat search queries that does an access control check is inefficient. It first checks the user_owner field in xml_documents (of dubious value), and then it does two queries against xml_access to determine if the user has rights to query. The query as implemented in Metacat 1.6 is attached. Note in particular that the user_owner part of the query appears to be wrong -- at no point would the user_owner ever be 'public', so this part of the query can be omitted for public searches, avoiding a large subquery.

soil-query5.sql (2.56 KB) soil-query5.sql Matt Jones, 09/28/2006 09:12 AM
access (1.46 KB) access Jing Tao, 07/24/2007 01:55 PM

Related issues

Blocked by Metacat - Bug #1879: Metacat Performance: SummaryNew01/18/2005

History

#2 Updated by Jing Tao over 12 years ago

The query part for search if the owner is public is omitted.

In extend query which will search return fields, it had a access part query too. The reason we needed it is because there was a subtree access control in first version of eml2. We decided to give up subtree access control in eml document, so there is no reason to keep the access query in return field part. This work is done.

#4 Updated by Jing Tao almost 12 years ago

Move to release 1.7.1

#5 Updated by Redmine Admin over 6 years ago

Original Bugzilla ID was 2557

Also available in: Atom PDF