Project

General

Profile

« Previous | Next » 

Revision 14368

Added by Aaron Marcuse-Kubitza over 10 years ago

inputs/.TNRS/schema.sql: taxon_match: `inputs/.TNRS/data.sql.run refresh`: documented runtime (1 min)

View differences:

trunk/inputs/.TNRS/schema.sql
596 596 

  		




  597
  597
  
    
to move a derived column to the middle or to add a non-derived column:


  		




  598
  598
  
    
make the changes in inputs/.TNRS/schema.sql


  		




  599
  
  
    
$ inputs/.TNRS/data.sql.run refresh # re-run TNRS


  		




  
  599
  
    
$ inputs/.TNRS/data.sql.run refresh # re-run TNRS; runtime: 1 min ("1m2.629s")


  		




  600
  600
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match'');


  		




  601
  601
  
    
SELECT util.derived_cols_repopulate(''"TNRS".taxon_match'');


  		




  602
  602
  
    
SELECT util.recreate_view(''"TNRS".taxon_best_match'');


  		












  

    
      trunk/schemas/vegbien.sql
    
  





  20257
  20257
  
    

  		




  20258
  20258
  
    
to move a derived column to the middle or to add a non-derived column:


  		




  20259
  20259
  
    
make the changes in inputs/.TNRS/schema.sql


  		




  20260
  
  
    
$ inputs/.TNRS/data.sql.run refresh # re-run TNRS


  		




  
  20260
  
    
$ inputs/.TNRS/data.sql.run refresh # re-run TNRS; runtime: 1 min ("1m2.629s")


  		




  20261
  20261
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match'');


  		




  20262
  20262
  
    
SELECT util.derived_cols_repopulate(''"TNRS".taxon_match'');


  		




  20263
  20263
  
    
SELECT util.recreate_view(''"TNRS".taxon_best_match'');


  		












Also available in:  Unified diff