Large Databases - Actual Memory Usage Chart
The above chart shows three series of figures:
Import New is the max. memory usage as a result of importing the given no. of animal records (from a CSV file) into a new (empty) database;
Import Merge is the same, but followed by the re-importation of the same data set; this tests out a merge on every record in the database, an expensive operation in terms of both CPU time and memory overhead.
System Memory is the amount of system memory (physical memory) present.
| #Records | 10,000 | 50,000 | 100,000 | 200,000 | 500,000 | 1,000,000 |
|---|---|---|---|---|---|---|
| Import New | 52Mb | 74Mb | 87Mb | 112Mb | 211Mb | 369Mb |
| Import Merge | 54Mb | 84Mb | 96Mb | 126Mb | 244Mb | 421Mb |
| System Memory | 64Mb | 128Mb | 128Mb | 256Mb | 512Mb | 512Mb |
