TEST CASE:
Compare how fast data can be copied between two Netezza appliances:
- Using Netezza Fluid Query connection which is Java JDBC driver
- Using nz_migrate, which is nzbackup/nzrestore behing the hood
RESULT:
nz_migrate in ASCII transfer mode is 20 times faster than JDBC, and 80 times faster in BINARY mode.
nz_migrate in ASCII transfer mode is 20 times faster than JDBC, and 80 times faster in BINARY mode.
DETAILS:
Copying 1 GB table from one system to another:
No comments:
Post a Comment