Re: node.js SQL performance issue

[Henrik Rützou <hr@xxxxxxxxxxxx>]

Sorry - typo, the first link should have /nodeproxy/ as well

On Sun, Feb 12, 2017 at 7:18 PM, Henrik Rützou <hr@xxxxxxxxxxxx> wrote:

> 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.
> });
>
>
> --
> Regards,
> Henrik Rützou
>
> http://powerEXT.com <http://powerext.com/>