do I need to worry about mysql connection pooling for node.js using sequelize?

Question

I'm new to node.js and have heard of connection pooling and it makes sense to me as the connection is an expensive operation.

I am looking at which node module to use for mysql and I like the look of Sequelize as it is an ORM.

I'm not sure if I need to worry about connection pooling with Sequelize. Do I just instantiate it and reuse it for all clients?

var sequelize = new Sequelize('database', 'username'[, 'password'])

Also, do I need to worry about the number of parallel queries being executed?

For example, if I am looping through a table and executing a query per row. What happens if there are 1000 or more rows?

Do those queries get executed all at once?

If so, is there a limit to the amount you can throw at it?

sdepold · Accepted Answer · 2011-11-11 07:51:35Z

5

at the very moment Sequelize is not using pooling. This caused many problems in the past, so it was removed. I will add pooling again in later versions of Sequelize. At the moment, every request opens a new connection. There is also a known bug, which leads to unclosed connections. Due to heavy enhancements in the next version, this will hopefully be fixed. I will also change from the currently used node-mysql to another mysql connector, which is much faster. Once this is done, I try to add pooling again.

answered Nov 11, 2011 at 7:51

sdepold

6,2262 gold badges43 silver badges47 bronze badges

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

3 Comments

Tim Over a year ago

Thanks sdepold, what about the parallel queries, does it hammer the db?

jonathancardoso Over a year ago

Sequelize v3 does have connection pool: github.com/sequelize/sequelize/blob/v3/docs/docs/…

Muhammad Shaharyar Over a year ago

can you please explain how to use pool ? is it necessary ? i cant understand the ussage in docs

Collectives™ on Stack Overflow

do I need to worry about mysql connection pooling for node.js using sequelize?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related