Project

General

Profile

« Previous | Next » 

Revision 8393

Added by ben leinfelder about 11 years ago

add indices for access log performance during upgrade to 2.3.0.

View differences:

src/upgrade-db-to-2.3.0-postgres.sql
1 1 
/*
2 
 * Add indices for log access
3 
 */
4 
CREATE INDEX identifier_docid_rev_log ON identifier((docid||'.'||rev));
5 
CREATE INDEX access_log_docid ON access_log(docid);
6 

  		




  
  7
  
    
/*


  		




  2
  8
  
    
 * update the database version


  		




  3
  9
  
    
 */


  		




  4
  10
  
    
UPDATE db_version SET status=0;


  		












  

    
      src/upgrade-db-to-2.3.0-oracle.sql
    
  





  1
  1
  
    
/*


  		




  
  2
  
    
 * Add indices for log access 


  		




  
  3
  
    
 */


  		




  
  4
  
    
CREATE INDEX identifier_docid_rev_log ON identifier((docid||'.'||rev));


  		




  
  5
  
    
CREATE INDEX access_log_docid ON access_log(docid);


  		




  
  6
  
    

  		




  
  7
  
    
/*


  		




  2
  8
  
    
 * update the database version


  		




  3
  9
  
    
 */


  		




  4
  10
  
    
UPDATE db_version SET status=0;


  		












Also available in:  Unified diff