SQL Server queries with small number of records crashing node app. Please help!

[Gabriel Salama]

I have been developing a node app that connects to a SQL Server database using mssql but I have run into a wall. Basically, mssql seems to have some kind of bug where it simply crashes the app if the results of a query of any kind returns a decent number of records. Nothing too heavy. I'm talking about 50 to 100 records!

The queries run fine if I limit them to return 10, 20, 40 records, but as soon as the resultset is larger than a certain number of records (it varies from query to query), the app simply crashes without a single error message. No exceptions. Nothing.

This is a show-stopper for me. It happens on all queries I have tried, on different tables, different databases. The results are always the same. It runs fine when the query returns just a few records (5, 10, 20, for example) but after gradually increasing the limit of records (using "SELECT TOP x ...") there comes a point in which the app just crashes. No error messages, no exception, nothing. The number at which the app crashes varies between the different queries but the behaviour is the same always.

Am I missing something? Is there I setting I should tweak to avoid this?

Alternatively, is there any other npm that I could use to connect to SQL Server?

Thank you!

[Gustavo Duarte]

Hi Gabriel,

I've had good luck with the Tedious module:

https://github.com/pekim/tedious

It has worked well under heavy load in production, handling large
result sets and just about any data type I have ever thrown at it.

Hope this helps,
Gustavo

> --
> Job board: http://jobs.nodejs.org/
> New group rules:
> https://gist.github.com/othiym23/9886289#file-moderation-policy-md
> Old group rules:
> https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
> ---
> You received this message because you are subscribed to the Google Groups
> "nodejs" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to nodejs+un...@googlegroups.com.
> To post to this group, send email to nod...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/nodejs/2425434e-8ccf-489f-a6bc-a80076c71cf9%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.