LDAS LHO Database Insertion Rates
Test Period March 1st, 2000
Input data XML for ilwds with dimensions 100
Platform metaserver.ligo-wa.caltech.edu (SUN 450, RAM=256MB, Solaris 2.7)
LDAS software ldas-0.0.9, IBM DB2 6.1 
Results are displayed in the order inserted.
Table #rows per block insert CPU time (secs) Wall Time (secs) Rate (#rows/sec)
process 100 0.34 0.659 151.75
process_params 100 0.25 0.382 261.78
frameset_chanlist 100 0.16 0.366 273.22
frameset_writer 100 0.26 0.513 194.93
frameset 100 0.23 0.379 263.85
frameset_loc 100 0.29 0.579 172.71
segment_definer 100 0.25 0.472 211.86
segment 100 0.15 0.239 418.41
summ_value 100 0.33 0.603 165.84
summ_statistics 100 0.28 0.556 179.86
summ_comment 100 0.29 0.711 140.65
summ_spectrum 100 0.00 0.00 0.00
filter 100 0.18 0.427 234.19
filter_params 100 0.22 0.353 283.29
gds_trigger 100 0.24 0.438 228.31
sngl_inspiral 100 0.31 0.718 139.28
sngl_burst 100 0.24 0.695 143.88
sngl_ringdown 100 0.15 0.345 289.86
sngl_unmodeled 100 0.25 0.535 186.92
sngl_unmodeled_v 100 0.17 0.303 330.03
sngl_dperiodic 100 0.25 0.555 180.18
sngl_datasource 100 0.25 0.426 234.74
sngl_transdata 100 0.00 0.00 0.00
multi_inspiral 100 0.24 0.515 194.17
multi_burst 100 0.22 0.816 122.55
coinc_sngl 100 0.40 0.971 102.98

Summary:

  1. Insertion rates are much faster due to use of IBM db2 driver instead of openlink software and improvement in the object space library handling of arrays.

  2. Insertion for tables summ_spectrum and sngl_transdata are not available for now due to a bug in the metadataAPI that rejects blob data.