Hi,
I've used all the weekend to do performance test on IBMi vs Win and must
say that
the new DB SQL connector db2a (introduced with node V4) performs badly, here
is som figures:
OS, Servertype, Client, Datasource, Runtime, Roundtrip
W, node.js, localhost, IFS, 1ms, 12ms ( zdemo01.js )
W, node.js, remote, IFS, 1ms, 25ms, (
http://powerext.org/proxy/zdemo01.js )
i, node.js, remote, IFS, 1.8ms, 35ms, (
http://5.103.128.110:6382/nodeproxy/zdemo01.js )
i, node.js, remote, DB2/SQL, 80ms, 125ms (
http://5.103.128.110:6382/nodeproxy/zdemo06.js )
i, CGI/YAJL, remote, DB2/SQL, 1.2ms, 46ms (
http://5.103.128.110:6382/pextcgicor/jonyajl.pgm )
W - Intel i3-3240, 3.4Ghz, 2core, 16GB-ram, Windows7
i - Power6, 4.2Ghz, 1core, 3GB-ram, V7R1M0, 20% cpu LPAR
Am I doing something wrong, my DB code is as follow:
// Input from DB2
var db = require('/QOpenSys/QIBM/ProdData/OPS/Node6/os400/db2i/lib/db2a');
var sql = "SELECT * FROM QIWS.QCUSTCDT FOR READ ONLY";
var sqlresult = ''; // The result of the SQL Query
var dbconn = new db.dbconn(); // Create a connection object.
dbconn.conn("*LOCAL"); // Connect to a database.
var stmt = new db.dbstmt(dbconn); // Create a statement object of the
connection.
stmt.prepareSync(sql); // Run the SQL
stmt.executeSync();
stmt.fetchAllSync(function callback(result) {
sqlresult = JSON.stringify(result, null, '\t');
delete stmt; // Clean up the statement object.
dbconn.disconn(); // Disconnect from the database.
delete dbconn; // Clean up the connection object.
});
As an Amazon Associate we earn from qualifying purchases.