Uploaded image for project: 'MariaDB Connector/node.js'
  1. MariaDB Connector/node.js
  2. CONJS-81

Improved Pooling

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • None
    • N/A
    • pool

    Description

      Read that knex.js and supposedly other DB drivers are switching over to tarn.js for their resource pooling.
      https://www.npmjs.com/package/tarn (Notice the surge in weekly downloads)

      Could this potentially be more beneficial for pooling?

      Attachments

        Activity

          diego dupin Diego Dupin added a comment -

          nice project and well written.

          Pool offer the same functionalities ( which is nice, mysql and mysql2 doesn't ! ).
          But there is no option not in internal pool, and internal pool has some additional benefits :

          • reliability: when a connection is released, transaction state is checked ( completely reset even )
          • efficiency: validation is on or off. default internal pool won't validate connection if used a few millisecond before, and that change drastically the time of one query. ( and a marginal thing : query will create a double promise when a single one if enough)

          So not this time, but the comparison is always nice (and coding style is better, give me some ideas for improving design)

          diego dupin Diego Dupin added a comment - nice project and well written. Pool offer the same functionalities ( which is nice, mysql and mysql2 doesn't ! ). But there is no option not in internal pool, and internal pool has some additional benefits : reliability: when a connection is released, transaction state is checked ( completely reset even ) efficiency: validation is on or off. default internal pool won't validate connection if used a few millisecond before, and that change drastically the time of one query. ( and a marginal thing : query will create a double promise when a single one if enough) So not this time, but the comparison is always nice (and coding style is better, give me some ideas for improving design)

          People

            diego dupin Diego Dupin
            knoxcard John
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.