LIMIT query runs really slow with node-hdb about node-hdb

[holgerkoser]

All queries with LIMIT I have ever executed returned very fast. I am not able to reproduce this issue with the given description of the problem. However, there two undefined variables in the code example. One is query the other is values. I also do not understand why you use prepared statement without any parameters. You also do not describe which columns your table contains ... How should I help if you do not describe in details what are you doing and provide all the information to reproduce the issue.

What is the result if you do not prepare?

console.time('no prepare');
client.exec("select * from TABLE where A=5 order by B limit 200", function(err, rows) {
  console.timeEnd('no prepare');
});

What is the result if you only select A?

console.time('select A');
client.exec("select A from TABLE where A=5 order by B limit 200", function(err, rows) {
  console.timeEnd('select A');
});

What is the result if you do not auto fetch complete rows?

console.time('no autoFetch');
client.execute("select * from TABLE where A=5 order by B limit 200", function(err, rs) {
  console.timeEnd('no autoFetch');
});

[abh1kg]

Hello Holger,
I should've closed this issue earlier and apologies for providing incomplete information. I should've mentioned that one of the columns in the table was of type NCLOB and I was auto-fetching all rows, instead of using a resultSet. Using a result set and some streaming logic, the fetch times are manageable now.

I am closing this. Thank you for your help and apologies once again.

Best Regards, Abhi