当使用poolConnection或CreateConnection felixge/node-mysql时 [英] When use poolConnection or CreateConnection felixge/node-mysql

问题描述

对于我的应用程序，我使用 https://github.com/felixge/node-mysql 何时何地使用

I use https://github.com/felixge/node-mysql for my application When and Why use

db_pool = mysql.createConnection(db);

或

db_pool = mysql.createPool(db);

有什么区别?以及何时使用它们?

what are the differences? and when to use them?

推荐答案

单个连接正在阻塞.在执行一个查询时，它无法执行其他查询.因此，您的数据库吞吐量可能会降低.

A single connection is blocking. While executing one query, it cannot execute others. Hence, your DB throughput may be reduced.

池管理着许多延迟创建的(在felixge的模块中)连接.当一个连接正忙于运行查询时，其他连接可用于执行后续查询.这样可以并行运行多个查询，从而提高应用程序性能.

A pool manages many lazily-created (in felixge's module) connections. While one connection is busy running a query, others can be used to execute subsequent queries. This can result in an increase in application performance as it allows multiple queries to be run in parallel.

这篇关于当使用poolConnection或CreateConnection felixge/node-mysql时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！