BioSPICE Time Tests2

Trials with database indexing on Iliad.ai.sri.com.

File Size MB  Warehouse Loader1 Oracle Loader File Creation2 Oracle Loader3 Total Oracle4
1.6 0:03:57 0:01:01 0:01:40 0:02:41
10 0:21:32 0:05:41 0:09:56 0:15:38
50 1:47:59 0:31:23 1:01:27 1:32:50
  1. The time the BioSPICE Warehouse Loader used to read, process and save the data to the database.
  2. In order for the Oracle Loader to work, each table of the schema needs a separate file containing the table's specific data..  Each file contains a header and the data that will be inserted into the database.  This is the length of time that the BioSPICE Warehouse Loader took to create those files.  No data was saved into the database during this step.
  3. The time the Oracle Loader used to read, process and save the loader files to the database.
  4. The summation of the Oracle Loader file creation time and the Oracle Loader time.