mariano/node-db-oracle — Issue #15: slow result sets
Author: troyk
Created: 2011-11-21 07:17:06+00:00
State: open

It seems anything beyond nominal result sets takes an extremely long time. The query below (500 rows of 3 columns) completes with ruby's activerecord in 1.4 seconds, while node takes about 34 seconds. If I limit the rows to 10, node it will run in .8 seconds. During the 34 seconds, node is not doing much, sitting idle barely hitting RAM or CPU.

```javascript
var startAt;
server.query().execute('SELECT "ORDER_NO","CUSTOMER_PO_NO","PRIMARY_CONTACT" FROM SF_RH_CUST_HEADER WHERE ROWNUM <= 500',[],function(err,rows){
console.log(rows);
},{
async:true,
cast:false,
finish:function(){
console.log('seconds: ', (new Date()-startAt)/1000);
},
start:function(){
console.log('start: ',startAt = new Date());
}
}
);

```