NodeJS/SailsJS app database block

Question

Understand that NodeJS is a single thread process, but if I have to run a long process database process, do I need to start a web worker to do that? For example, in a sails JS app, I can call database to create record, but if the database call take times to finish, it will block other user from access the database.

Below are a sample code i tried

var test = function(cb) {
                for(i=0;i<10000;i++) {
                    Company.create({companyName:'Walter Jr'+i}).exec(cb);
                }
            }
            test(function(err,result){

            });
            console.log("return to client");
            return res.view('cargo/view',{
                model:result
            });

On first request, I see the return almost instant. But if I request it again, I will need to wait for all the records being entered before It will return me the view again.

What is the common practice for this kinda of blocking issue?

Mahdi Pedram · Accepted Answer · 2015-06-28 17:24:48Z

3

Node.js has non-blocking, asynchronous IO.

read the article below it will help you to restructure your code http://hueniverse.com/2011/06/29/the-style-of-non-blocking/

Also start using Promises to help you avoid writing blocking IO.

answered Jun 28, 2015 at 17:24

Mahdi Pedram

7496 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Chris Sim Over a year ago

Hi, thanks for the link. But I have already read that before I post here. I think it's my database query blocking the code, as it has no issue when accessing other part of the application that don't need db connection while the query is still running

Mahdi Pedram Over a year ago

what you need to do is use Promises and return the Promise in the test function, so your function will return the promise right away, and within the promise you can start writing to the DB.

Collectives™ on Stack Overflow

NodeJS/SailsJS app database block

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related