Project

General

Profile

Actions

Bug #2557

closed

Metacat Performace: Rewrite the xml_access part of the query

Added by Matt Jones about 18 years ago. Updated about 17 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.


Files

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: SummaryNewJing Tao01/18/2005

Actions
Actions

Also available in: Atom PDF