LDAS CIT Database Insertion Rates
Test Period December, 1999
Input data Ilwd with dimensions 10, 100
Platform deneb.ligo.caltech.edu (SUN Ultra 1, RAM=128MB, Solaris 2.7)
LDAS software ldas-0.0.6 
Results are displayed in the order inserted.
Table #rows per block insert CPU time (secs) Wall Time (secs) Rate (#rows/sec)
process 10 0.52 6 1.67
process 100 4.75 78 1.28
process_params 10 0.22 10 1.00
process_params 100 2.07 37 2.70
frameset_chanlist 10 0.27 11 0.91
frameset_chanlist 100 1.78 41 2.44
frameset_writer 10 0.39 9 1.11
frameset_writer 100 2.83 40 2.50
frameset 10 0.55 5 2.00
frameset 100 3.52 53 1.89
frameset_loc 10 0.33 10 1.00
frameset_loc 100 3.03 53 1.87
segment_definer 10 0.22 14 0.71
segment_definer 100 1.85 38 2.63
segment 10 0.30 6 1.67
segment 100 2.11 30 3.33
summ_value 10 0.55 18 0.56
summ_value 100 3.97 66 1.52
summ_statistics 10 0.62 11 0.91
summ_statistics 100 6.16 91 1.09
summ_comment 10 0.65 16 0.63
summ_comment 100 4.9 84 1.19
summ_spectrum 10 0.57 17 0.59
summ_spectrum 100 4.12 89 1.12
filter 10 0.34 5 2.00
filter 100 2.42 43 2.33
filter_params 10 0.32 4 2.50
filter_params 100 2.63 41 2.44
gds_trigger 10 0.47 8 1.25
gds_trigger 100 6.58 90 1.11
sngl_inspiral 10 0.61 9 1.11
sngl_inspiral 100 5.65 75 1.33
sngl_burst 10 0.68 6 1.67
sngl_burst 100 4.72 57 1.75
sngl_ringdown 10 0.47 6 1.67
sngl_ringdown 100 4.77 59 1.69
sngl_unmodeled 10 0.52 7 1.43
sngl_unmodeled 100 5.51 54 1.85
sngl_unmodeled_v 10 0.39 3 3.33
sngl_unmodeled_v 100 2.85 30 3.33
sngl_dperiodic 10 0.58 17 0.59
sngl_dperiodic 100 5.41 101 0.99
sngl_datasource 10 0.45 15 0.67
sngl_datasource 100 3.46 53 1.89
sngl_transdata 10 0.84 13 0.77
sngl_transdata 100 3.98 89 1.12
multi_inspiral 10 0.49 13 0.77
multi_inspiral 100 5.97 85 1.18
multi_burst 10 0.61 8 1.25
multi_burst 100 6.21 70 1.43
coinc_sngl 10 1.21 15 0.67
coinc_sngl 100 13.78 132 0.76

Summary:

  1. Insertion rate is very slow on deneb due to small memory.
  2. Smaller tables insert faster. Tables with blobs such summ_spectrum and sngl_transdata insert slowest.
  3. No significant memory leaks were seen during the insertion. The size of metadataAPI process remains around 12MB.