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 On Tue, Feb 3, 2015 at 6:37 PM, Gabriel Salama <[email protected]> wrote: > 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! > > -- > 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 [email protected]. > To post to this group, send email to [email protected]. > 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. -- 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 [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/nodejs/CAOfexA0XcLYHiHyWZOojou2JYYStCxYu-KvZX8UzPOTrTLVzcA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
