{"id":3995,"date":"2024-07-17T14:34:36","date_gmt":"2024-07-17T07:34:36","guid":{"rendered":"https:\/\/www.sqlservertutorial.net\/?page_id=3995"},"modified":"2024-07-22T07:57:11","modified_gmt":"2024-07-22T00:57:11","slug":"nodejs-sql-server-stream","status":"publish","type":"page","link":"https:\/\/www.sqlservertutorial.net\/nodejs-sql-server\/nodejs-sql-server-stream\/","title":{"rendered":"Node.js SQL Server: Stream"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the stream to process large result sets more efficiently.<\/p>\n\n\n\n

This tutorial begins where\u00a0the\u00a0Calling a stored procedure with an OUTPUT parameter in Node.js tutorial<\/a>\u00a0left off.<\/p>\n\n\n\n

How to use Node.js stream to handle large result sets #<\/a><\/h2>\n\n\n\n

A stream allows you to handle a large result set efficiently by processing it row by row, rather than loading it into memory at once.<\/p>\n\n\n\n

The stream is useful when you handle large result sets from SQL Server without consuming much server memory.<\/p>\n\n\n\n

The following describes the steps for using the stream:<\/p>\n\n\n\n

First, connect to the SQL Server<\/a>:<\/p>\n\n\n

const<\/span> pool = await<\/span> sql.connect(config);<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
Second, create a Request<\/code> object that represents a query executed against the SQL Server and enables streaming:<\/p>\n\n\n
const<\/span> request = new<\/span> sql.Request(pool);\nrequest.stream = true<\/span>;<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
Third, handle data when it arrives. To do that, you use the on()<\/code> method of the Request<\/code> object. The request.on()<\/code> method handles various events that occur during the execution of a query when the stream is enabled:<\/p>\n\n\n\n