Wednesday, November 2, 2016

Netezza: data transfer speed Fluid Query JDBC v.s. nz_migrate

TEST CASE:
Compare how fast data can be copied between two Netezza appliances: 
  1. Using Netezza Fluid Query connection which is Java JDBC driver
  2. 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. 

DETAILS

Copying 1 GB table from one system to another: