LDAS CIT Database Insertion Rates
Test Period February 23th, 2000
Input data Ilwd with dimensions 100
Platform metaserver.ligo.caltech.edu (SUN 450, 4 CPUs, RAM=1024MB, 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.23 0.386 259.06
process_params 100 0.18 0.247 404.86
frameset_chanlist 100 0.11 0.292 342.47
frameset_writer 100 0.20 0.337 296.74
frameset 100 0.16 0.250 400.00
frameset_loc 100 0.22 0.307 325.73
segment_definer 100 0.18 0.269 371.75
segment 100 0.10 0.180 555.56
summ_value 100 0.23 0.354 282.49
summ_statistics 100 0.19 0.384 260.42
summ_comment 100 0.28 0.469 215.98
summ_spectrum 100 0.00 0.00 0.00
filter 100 0.14 0.289 215.98
filter_params 100 0.17 0.252 396.83
gds_trigger 100 0.24 0.438 228.31
sngl_inspiral 100 0.18 0.358 279.33
sngl_burst 100 0.14 0.332 301.20
sngl_ringdown 100 0.15 0.345 289.86
sngl_unmodeled 100 0.18 0.355 281.69
sngl_unmodeled_v 100 0.13 0.189 529.10
sngl_dperiodic 100 0.16 0.375 266.67
sngl_datasource 100 0.18 0.255 392.16
sngl_transdata 100 0.00 0.00 0.00
multi_inspiral 100 0.17 0.354 282.49
multi_burst 100 0.16 0.351 284.90
coinc_sngl 100 0.28 0.634 157.73

Summary:

  1. Insertion rate is generally about 1.25-1.50 times faster due to 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.