Result Details

Stored Procedure Name

Result Details

Duration

select count(distinct gid) 
from germplsm;

Count study datasets

select distinct(count e.represno) 
from effect e, factor f 
where e.factorid = f.factorid;

select count(*) 
from wh_columns;

select count(*)
from wh_data;

select count(*)
from wh_datasets;

2 GB RAM

2 GB RAM

reported :

ERROR 1054 (42S22): Unknown column 'c.datacol' in 'where clause'

• get_wh_columns

• assign_column_order
  

• get_wh_data
  

• get_wh_data_all_row_numbers
  

• 4 min 16.27 sec
• 6 min 14.52 sec
  
• 3 hours 30 min 27.28 sec
  
• 5 hours 26 min 21.49 sec
  

IRIS

iris_myisam from backup made Sept 28, 2008

TODO: check if correct values were stored

TODO: check if correct values were stored

No log about completion of data Population

TODO: verify

Castor Server

see bottom of page for specs

June 28, 2009,

11:00

1/3 tables done

ERROR yet unknown/ session terminated

• get_wh_columns

• assign_column_order

• 10 min
• 10 min

iwis3_myisam

Castor Server

see bottom of page for specs

20:00

ERROR: Disk Space Full for writing

• get_wh_columns

• assign_column_order

• 9 min

• 10 min

IWIS

iwis3_myisam

see bottom of page for specs

July 02, 2009,

4:40

• get_wh_columns

• assign_column_order

• get_wh_data
  

• get_wh_data_all_row_numbers

• set_wh_data_dataval_with_valdesc

TOTAL RUNTIME:

15 hours and 10 mins

(see bottom of page for specs)

Process stopped after get_wh_data().

get_wh_data_all_row_numbers() CALLed manually.

• 10 minutes: get_wh_columns(), assign_column_order()

• get_wh_data
  

• get_wh_data_all_row_numbers

• set_wh_data_dataval_with_valdesc

Duration unknown

2 GB RAM

July 3, 2009,

16:10

• get_wh_columns

• assign_column_order

• get_wh_data

• get_wh_data_all_row_numbers

• set_wh_data_dataval_with_valdesc
  

• 4 min 32.80 sec
  

• 6 min 28.66 sec
  
• 3 hours 22 min 59.41 sec
  
• 5 hours 26 min 57.09 sec
  
• no log
  

iris_myisam from backup made Sept 28, 2008

• get_wh_columns

• assign_column_order

• get_wh_data

• get_wh_data_all_row_numbers

• set_wh_data_dataval_with_valdesc

• 1 min, 12.44 secs

• 5 min, 32.25 sec

IMIS

imis_myisam

(activate_cropfinder_warehousing())

• create_fieldsetup()
  
• create_factors()

IWIS3

iwis3_myisam

IWIS3

iwis3_public_07072009

IRIS

iris_myisam

IWIS3

iwis_myisam

CRIL4

(see bottom of page for specs)

Completed in 1 day 9 hours 58 mins 54.46 sec (397 records in wh_countdatapoints)

IWIS3 central

iwis3p_myisam_20090918

(see bottom of page for specs)

Able to process the create_fieldsetup() and it took 1 min and plus seconds.

The create_factors() process took 2 days plus and didn't continue. 

(see bottom of page for specs)

The create_factors() process took 2 days 15 hours 12 mins 33.17 secs.

The create_variates() has an error "unknown column w.valtype in field list". The w.valtype should be in wh_countdatapoints. The create_icis_dms_warehouse.sql that creates the wh_countdatapoints is the previous version before the cropfinder warehouse is updated.

IWIS3 public

IWIS3 central

5,068,850

5,258,801

596

600

72,137

72,152

57,405,518

58,806,065

2,080

2,086

(see bottom of page for specs)

IRIS iris_myisam_20091006

IRIS central

2,826,697

1944

(see bottom of page for specs)

IRIS iris_myisam_20091106

IRIS central