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 |
- The time the BioSPICE Warehouse Loader used to read, process and save the
data to the database.
- 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.
- The time the Oracle Loader used to read, process and save the loader files
to the database.
- The summation of the Oracle Loader file creation time and the Oracle
Loader time.