Solved thread

This post is marked as solved. If you think the information contained on this thread must be part of the official documentation, please contribute submitting a pull request to its repository.

  1. Home
  2. ORM

Does Phalcon supports persistent DB connection?

Hi. My question is about connection pooling.

Does Phalcon natively supports DB connection pooling? Or: Can I create persistent DB connection like in mysql: mysql_pconect() (or with "p:" prefix in hostname)?

4


419
Accepted
answer
edited Oct '14

You can make phalcon to create persistent DB connections when setting up the DB service with settings array like this:

app/config/config.ini 

[database]
username        = myuser
password        = mypassword
dbname          = mydb
host            = 127.0.0.1
persistent      = true
encoding        = UTF8

public/index.php

  $config = new Phalcon\Config\Adapter\Ini(__DIR__ . '/../app/config/config.ini');

(...)

    //Set the database service
    $di->set('db', function() use ($config){
        return new \Phalcon\Db\Adapter\Pdo\Mysql(array(
            "host"      => $config->database->host,
            "username"  => $config->database->username,
            "password"  => $config->database->password,
            "dbname"    => $config->database->dbname,
            "charset"   => $config->database->encoding,
            "persistent"=> $config->database->persistent
        ));
    });


35.1k

Thank you! I did not find it in the API docs...



419

You can see other settings that might be useful here:

http://docs.phalcon.io/en/latest/reference/db.html#connecting-to-databases



35.1k

Yeah, I need to re-read docs now... I read full docs for Phalcon a year ago, after - only changelogs :)