poor performance of resultSetIterator.rows.next()

[andrejs-sisojevs]

We did a stress test to our module:

• query 10k rows
• each row containing 20 columns
• each row with size of 8.5KB
• expect query to download results within 20 seconds

Module based on node-jdbc downloaded results in 80 seconds. Profiling showed resultSetIterator.rows.next() to work slowly (resultSetIterator is obtained by calling resultSet.toObjectIter()).

We had to abandon node-jdbc and rewrite DB client part of system in Java, and call it using nodejs subprocess spawn. It now performs fine.

[theterra]

@andrejs-sisojevs-accenture Can you share an example code. how you resolved it?