mariano / node-db-mysql

MySQL database bindings for Node.js
http://nodejsdb.org
150 stars 30 forks source link

Segmentation fault with large result sets #67

Open Morgon opened 12 years ago

Morgon commented 12 years ago

It would appear that very large result sets (5 million rows) causes a segfault.

this.query()
    .on('each', function(row, index, last) { console.log(row, index); })
    .select(["id", "name", "country"])
    .from("users")
    //.limit(1000)
    .execute(function(err, rows) {
        if (err) {
            console.log('SQL ERR: ' + err);
            return;
        }
    });

If I have the limit in there, it works fast and just fine. If I time the node process, it's almost exactly 10 seconds before it fails.

db-mysql 0.7.6 node 0.6.15