Found some bench figures here:
https://github.com/patriksimek/node-mssql/issues/15. Looks like C++ driver
is the fastest.
Bruno
On Saturday, April 19, 2014 12:13:46 AM UTC+2, Bruno Jouhier wrote:
>
> Thanks Alejandro.
>
> What if your query returns zillions of rows (and you really want them all
> because you are doing some kind of data pump)?
> You cannot use the callback API and I did not see how you could control
> the flow of "row" events with the event API. Do you have any experience
> with this?
>
> Did you bench the drivers? I'm curious about the performance of a C++
> driver vs. a pure JS TDS driver like tedious.
>
> Bruno
>
> On Saturday, April 19, 2014 12:04:19 AM UTC+2, Alejandro Paciotti
> Iacchelli wrote:
>>
>> I am developing an app that has to read data from SQLSERVER.
>> After much reading and testing, I decided to use mssql.
>>
>> "mssql": "*" in my package.json
>> npm install
>>
>> and as an example:
>>
>> *var sql = require ('mssql'); *
>> *var database = {user = 'youruser', password = 'yourpass', server =
>> 'localhost', database= 'yourdatabasename' port = 1433};*
>>
>> *var connection = new sql.Connection (database, function (err) {*
>>
>> *var request = new sql.Request (connection); *
>>
>> *request.query ('SELECT * FROM your_view', function (err,
>> rsDatosClientes) {*
>>
>>
>> *rsDatosClientes; *
>>
>> *res.json (rsDatosClientes); *
>> *}); *
>> *});*
>>
>>
>> It work for me.
>>
>> Good Luck!
>>
>>
>>
>>
>>
>> [email protected]
>>
>>
>> 2014-04-18 18:44 GMT-03:00 Bruno Jouhier <[email protected]>:
>>
>>> Thanks Ben,
>>>
>>> I took a look at it before asking and I was wondering how people can use
>>> it to stream the rows returned by very large queries. The callback API is
>>> unhelpful for this and I did not see any pause/resume API to control the
>>> flow of row events. Tedious does not seem to hande this either (but I only
>>> took a quick look).
>>>
>>> The mysql driver gave me the right API. For oracle, I had to extend the
>>> driver with a reader API because the existing API was too simplistic. I was
>>> hoping to get this out of the box from mssql drivers but it looks like I'll
>>> have to implement it.
>>>
>>> Bruno
>>>
>>> On Friday, April 18, 2014 10:19:30 PM UTC+2, Ben Noordhuis wrote:
>>>
>>>> On Fri, Apr 18, 2014 at 8:24 PM, Bruno Jouhier <[email protected]>
>>>> wrote:
>>>> > Just looked at the official driver project
>>>> > (https://github.com/Azure/node-sqlserver) and was very disappointed
>>>> to see
>>>> > that it has not been updated for more than 1 year.
>>>> >
>>>> > Tedious (https://github.com/pekim/tedious) seems to be the only
>>>> really
>>>> > active project. Is this the right?
>>>> > Anyone willing to share his/her experience with mssql drivers?
>>>> >
>>>> > Bruno
>>>>
>>>> As a datum point: all the people I know that use iisnode, also use
>>>> msnodesql a.k.a. node-sqlserver. That's a sample size of ~10 so make
>>>> of it what you will.
>>>>
>>>> And yeah, the last commit was nine months ago. I'm not sure if that
>>>> means it's unmaintained or that everything just works but the open
>>>> issue count suggests it's the former.
>>>>
>>> --
>>> --
>>> Job Board: http://jobs.nodejs.org/
>>> Posting guidelines:
>>> 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 post to this group, send email to [email protected]
>>> To unsubscribe from this group, send email to
>>> [email protected]
>>> For more options, visit this group at
>>> http://groups.google.com/group/nodejs?hl=en?hl=en
>>>
>>> ---
>>> 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].
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
--
--
Job Board: http://jobs.nodejs.org/
Posting guidelines:
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 post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
---
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].
For more options, visit https://groups.google.com/d/optout.
