Project

General

Profile

Activity

From 06/25/2005 to 07/24/2005

07/21/2005

04:59 PM Revision 2518 (metacat): Added target for upgrading DB to version 1.6
sgarg
04:54 PM Revision 2517 (metacat): Changed the name of the function
sgarg
04:52 PM Revision 2516 (metacat): Modified xmltables script so that:
1. Foreign key for rootnodeid in xml_revision points to xml_node_revision table instead of xml_nodes
2. Added a new...
sgarg
04:46 PM Revision 2515 (metacat): Fixed bug in previous commit
sgarg
04:31 PM Revision 2514 (metacat): Modified postgres script so that:
1. Foreign key for rootnodeid in xml_revision points to xml_node_revision table instead of xml_nodes
2. Added a new t...
sgarg
04:18 PM Revision 2513 (metacat): Added a new property 'indexed_paths'. All the paths mentioned under this property will be configured in xml_path_index table.
See bug 2154 sgarg
04:08 PM Revision 2512 (metacat): Added a new function which can used to control the carriage return at the end of the debug message and 'Metacat' in front of the message...
sgarg

07/20/2005

01:07 PM Bug #2153: Metacat Performace: Add/drop indices on key columns

Indexes can also be added to docid and nodetype in xml_nodes.....
Saurabh Garg
10:28 AM Bug #2152: Metacat Performace: Reduce size of xml_nodes table

From Postgres documentation, the limits on the sequence...
"Sequences are based on bigint arithmetic, so the range c...
Saurabh Garg

07/19/2005

12:42 PM Bug #2154: Metacat Performace: Configurable path condition indices

It will also speed up queries like the following which are used while creating
the doclist...
select xml_nodes.d...
Saurabh Garg

07/13/2005

06:37 PM Bug #2154: Metacat Performace: Configurable path condition indices

From my email:
Metacat can have a new index table for admin specified fields. This will be
helpful as both xml_nod...
Saurabh Garg
06:16 PM Bug #2154 (Resolved): Metacat Performace: Configurable path condition indices
From Matt's email...
Configurable path condition indices -- this would allow admins to
configure specific XML pat...
Saurabh Garg
06:35 PM Bug #2152: Metacat Performace: Reduce size of xml_nodes table

While implementing this, have to check whats the limit on the sequence numbers
that are being assigned to xml_nodes...
Saurabh Garg
06:11 PM Bug #2152 (Resolved): Metacat Performace: Reduce size of xml_nodes table
xml_nodes is huge (6.8x106 records), and grows with every insert and
update by many thousands of records. By design...
Saurabh Garg
06:34 PM Bug #2159 (New): Metacat Performance: Divide xml_nodes based on the doctype
Matt suggested that xml_nodes table can probably be divided into multiple
tables based on the doctype. For example,...
Saurabh Garg
06:27 PM Bug #2158 (Resolved): Metacat Performance on KNB: Bring the logging level down on ecoinfo.
Dont know how much this effects the performance but we might be logging more
than required on the production server...
Saurabh Garg
06:24 PM Bug #2157 (Resolved): Metacat Performance: Optimize Postgres and Tomcat...
There might be some options in Tomcat to speed things up a little bit. e.g.
Chris suggested about turning off autol...
Saurabh Garg
06:20 PM Bug #2156 (Resolved): Metacat Performance: Send result back to web client in blocks
Comparing Metacat with other search engines, there is a major
difference in the metacat web interface when compared ...
Saurabh Garg
06:17 PM Bug #2155 (In Progress): Metacat Performace: Rewrite the xml_nodes queries
From Matt's email...
Rewrite the xml_nodes queries. In general we use the IN clause a lot
which is less than eff...
Saurabh Garg
06:14 PM Bug #2153 (Resolved): Metacat Performace: Add/drop indices on key columns
From Matt's email...
DB indices aren't created on some key columns such as
xml_nodes.nodedata (originally because...
Saurabh Garg
02:39 PM Revision 2511 (metacat): Add servlet mapping for replication.
Jing Tao

07/12/2005

03:24 PM Bug #2136: Replicate deleted documents in Replication
Here is the new approach:
When metacat A send a command "update" to metacat B, B will send two doclist to A.
The fir...
Jing Tao

07/07/2005

09:00 AM Revision 2510 (metacat): Changes made to the address and abstract sections of the data registry form and guide by Veronique Connolly.
sgarg

07/05/2005

11:54 AM Bug #2136 (Resolved): Replicate deleted documents in Replication
Currently in Delta-timed replication, metacat only replicated the documents in
xml_documents table. So even after th...
Jing Tao
 

Also available in: Atom