Large Databases - CPU Usage
The above chart shows two sets of timings:
Import New is the CPU time required to import the given no. of animal records (from a CSV file) into a new (empty) database;
Import Merge is the CPU time required to re-import of the same data set into a database containing that data; this tests out a merge on every record in the database, an expensive operation in terms of both CPU time and memory overhead.
| #Records | 10,000 | 50,000 | 100,000 | 200,000 | 500,000 | 1,000,000 |
|---|---|---|---|---|---|---|
| Import New | 0:50s | 4:27s | 9:27s | 21:48s | 1:23:45s | 3:19:09s |
| Import Merge | 1:15s | 5:25s | 11:45s | 31:18s | 2:04:23s | 5:01:38s |
