Project

General

Profile

Actions

Bug #2155

open

Metacat Performace: Rewrite the xml_nodes queries

Added by Saurabh Garg over 19 years ago. Updated over 15 years ago.

Status:
In Progress
Priority:
Immediate
Assignee:
Category:
metacat
Target version:
Start date:
07/13/2005
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
2155

Description

From Matt's email...

Rewrite the xml_nodes queries. In general we use the IN clause a lot
which is less than efficient. We need to evaluate how our current
queries are working and rewrite them. With some systematic work we can
probably come up with some similar ideas for improvements


Files

soil-query1.sql (3.93 KB) soil-query1.sql Matt Jones, 09/28/2006 08:46 AM
soil-query3.sql (2.98 KB) soil-query3.sql Matt Jones, 09/28/2006 08:49 AM
soil-query3a.sql (2.98 KB) soil-query3a.sql Matt Jones, 09/28/2006 08:51 AM
MetacatOriginalQueryWithIntersectFrom1.7+ (3.75 KB) MetacatOriginalQueryWithIntersectFrom1.7+ Jing Tao, 04/12/2007 06:01 PM
metacat-intersect-new.txt (2.62 KB) metacat-intersect-new.txt Matt Jones, 04/13/2007 07:35 AM
extendedQuery (833 Bytes) extendedQuery Jing Tao, 05/09/2007 02:41 PM
extendedQuery (839 Bytes) extendedQuery Jing Tao, 05/09/2007 02:47 PM
AttributeQuery (573 Bytes) AttributeQuery Jing Tao, 05/09/2007 02:48 PM
XML_QueryResultQuery (448 Bytes) XML_QueryResultQuery Jing Tao, 05/09/2007 02:50 PM
timing_result (6.79 KB) timing_result Jing Tao, 05/09/2007 10:18 PM
land_delimitered.ods (22.9 KB) land_delimitered.ods Jing Tao, 05/14/2007 02:35 PM
land_with_attribute_delimitered.ods (20.3 KB) land_with_attribute_delimitered.ods Jing Tao, 05/14/2007 02:38 PM
metacat.debug.ods (22.8 KB) metacat.debug.ods Jing Tao, 06/06/2007 11:09 AM
metacat.debug2.ods (22.4 KB) metacat.debug2.ods Jing Tao, 06/08/2007 10:39 AM
metacat.debug.ods (16 KB) metacat.debug.ods Jing Tao, 06/08/2007 03:47 PM
metacat.debug.ods (19.5 KB) metacat.debug.ods Jing Tao, 06/11/2007 10:56 AM
metacat.debug.ods (19.1 KB) metacat.debug.ods Jing Tao, 06/12/2007 09:30 AM
metacat.debug.ods (11 KB) metacat.debug.ods Jing Tao, 06/19/2007 11:55 AM
metacat.debug.ods (11.3 KB) metacat.debug.ods Jing Tao, 06/21/2007 03:07 PM
knb-default-selection-query (1.06 KB) knb-default-selection-query Jing Tao, 06/21/2007 03:54 PM
oringalIntersectQuery (1.55 KB) oringalIntersectQuery Jing Tao, 07/13/2007 04:40 PM
newIntersectQuery (1.46 KB) newIntersectQuery Jing Tao, 07/13/2007 05:14 PM
metacat.debug.ods (11.3 KB) metacat.debug.ods Jing Tao, 07/27/2007 02:39 PM
metacat.debug.ods (10.4 KB) metacat.debug.ods Jing Tao, 07/27/2007 04:28 PM
metacat.debug.ods (9.92 KB) metacat.debug.ods Jing Tao, 07/27/2007 05:19 PM
metacat.debug.ods (10 KB) metacat.debug.ods Jing Tao, 07/27/2007 06:24 PM
graph.ods (9.37 KB) graph.ods Jing Tao, 07/27/2007 06:43 PM
orgin (977 Bytes) orgin Jing Tao, 10/31/2007 11:39 AM
new (994 Bytes) new Jing Tao, 10/31/2007 11:41 AM
Query1 (157 Bytes) Query1 Jing Tao, 11/01/2007 07:13 PM
Query1 (303 Bytes) Query1 Jing Tao, 11/01/2007 09:38 PM
Query2 (1001 Bytes) Query2 Jing Tao, 11/01/2007 09:40 PM
Query3 (1.22 KB) Query3 Jing Tao, 11/01/2007 09:44 PM
Query4 (288 Bytes) Query4 Jing Tao, 11/01/2007 09:46 PM

Related issues

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

Actions
Actions

Also available in: Atom PDF