php.activerecord

For one thing, php-ar uses PDO connection objects and those have no "close()" method ... so there's not an easy way to kill a connection.

I'm not sure how a number of connections would become a problem though -- the ConnectionManager class uses the singleton pattern to avoid opening multiple connections to the same resource.

If the number of connections are maxing out I'd guess that the problem is poor programming, a poor hosting service or a combination of the two. If php-ar is used correctly it would be very difficult to max out those connections without a number of very long-running scripts working simultaneously.

Hi,

I have developed a multilingual website. I'm storing the translations in the database. I have a function to get the translation based on the key given. For example :

function get_translation($key,$language){
if($language=='THAI'){
// Get Thai translation from database for the given $key
}
}

If im getting translation for 50 words. Will the DB connection called 50 times ?
Because i came across the error 'too many connection'.

Any best practices to avoid "too many connection" error ?

Thanks

How are you initializing the ActiveRecord Config? Is it like the following?

 1 // Specify available connections
 2 $conns = array(
 3   'development'  => 'mysql://user:[email protected]/my_db',
 4   'production'  => 'mysql://user:[email protected]/my_db'
 5 );
 6 
 7 // Initialize ActiveRecord configuration
 8 ActiveRecord\Config::initialize(function($c) use ($conns) {
 9   $c->set_model_directory(MODELS);
10   $c->set_connections($conns);
11   $c->set_default_connection('development');
12 });

Because when you do it this way the connections are stored in the Singleton ConnectionManager object where they'll only be established once. Then, when a model needs a connection it checks to see if a connection of the same name has been already been created in the ConnectionManager. If so, it reuses the existing connection and won't establish a new one.

This may be slightly off topic but you also have the capability of specifying which connection specific models use by setting the static $connection property inside a model. So, for example:

1 // This model uses the production server instead of the default
2 class MyModel extends ActiveRecord\Model
3 {
4   static $connection = 'production';
5 }

Thanks for the reply .

My init methods is :

ActiveRecord\Config::initialize(function($cfg)
{
        $cfg->set_model_directory(PATH.'models');
        $cfg->set_connections(array('development' => 'mysql://root:@127.0.0.1/mydb?charset=utf8'));
    });

Does this method has any issues ? My site has not gone live yet , so maximum 10-20 people may be using it for testing. But still i got the 'too many connection' error . Any idea whats causing it ?
(default max connections is 101)