How long does it take for full backup of 100G database? (Both zip and no zip) (DBMR 1935; version: DBMaker bundle 4.3.3)
There are about 2 factors that will affects the full backup time, they are:
Data type: When doing full backup with zip, compressed situation is different according to different data situation. Ordinary data is better compressed than multimedia data.
Zip or no zip: because cost time between CPU and I/O is different. And full backup with zip mainly spends CPU, and full backup with no zip spends I/O, but the speed of CPU is much faster than I/O. Generally speaking, full backup with zip is better choice than with no zip. Except that the compressed scale is much bad.
In addition, we still tested two supposed situation. Due to limitation of hardware, the tested database was about 50G.
Please refer to the following table:
Windows |
Time(unit: second) |
Size of backup Dir |
|
Empty DB(51.9G) (DB_BkSvr = 1) |
No zip backup |
2848 |
51.9G |
Zip backup (DB_BKZIP = 1) |
1796 |
115M |
|
Insert some ordinary and blob data(53.7G) (DB_BkSvr = 1 DB_BKFOM =2 DB_BMODE =2) |
No zip backup |
3045 |
53.7G |
Zip backup (DB_BKZIP = 1) |
2022 |
3.65G(including fo dir) |
Testing method: using JServer manager of normal 4.3.3 to test online full backup.