Project

General

Profile

« Previous | Next » 

Revision 3505

Added by Jing Tao almost 17 years ago

Add two indexes to improve delete and upgrade performance.

View differences:

upgrade-db-to-1.7.1-postgres.sql
38 38 

  		




  39
  39
  
    
CREATE INDEX xml_index_idx2 ON xml_index (docid);


  		




  40
  40
  
    
CREATE INDEX xml_nodes_idx4 ON xml_nodes (docid);


  		




  
  41
  
    
CREATE INDEX xml_documents_idx3 ON xml_documents (rootnodeid);


  		




  
  42
  
    
CREATE INDEX xml_index_idx3 ON xml_index (nodeid);


  		












Also available in:  Unified diff