Project

General

Profile

« Previous | Next » 

Revision 10280

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/.TNRS/schema.sql: tnrs_populate_fields(): updated runtimes. it now takes 25 min instead of 16 min to regenerate the derived cols.

View differences:

inputs/.TNRS/schema.sql
89 89 

  		




  90
  90
  
    
/* IMPORTANT: when changing this function, you must regenerate the derived cols:


  		




  91
  91
  
    
UPDATE "TNRS".tnrs SET "Name_submitted" = "Name_submitted"


  		




  92
  
  
    
runtime: 16 min ("5052509 rows affected, 980692 ms execution time")


  		




  
  92
  
    
runtime: 25 min ("5221748 rows affected, 1524228 ms execution time")


  		




  93
  93
  
    
VACUUM ANALYZE "TNRS".tnrs -- to remove previous rows


  		




  94
  
  
    
runtime: 50 s ("48264 ms")


  		




  
  94
  
    
runtime: 1 min ("62350 ms")


  		




  95
  95
  
    
*/


  		




  96
  96
  
    
CREATE OR REPLACE FUNCTION tnrs_populate_fields()


  		




  97
  97
  
    
  RETURNS trigger AS


  		












Also available in:  Unified diff