Yii: New DB connections when using CActiveRecord Cache

Question

I'm using cache in CActiveRecord as:

$myoboject = ListModel::model()->cache(60)->findAll();

According to documentation it caches the result set for 60 seconds.

I would like to ask, will it open a new DB connection if another request will come within 60 second ? What I think it should not do like this, instead it should fetch the cached data.

I'm having this problem because I wanted to avoid the multiple db connection being opened by a script and I want to cache the data for 60 seconds, and after that it can be invalidated.

Am I on the right track ? is this a normal behaviour ? will anybody please let me know if there is something wrong ?

I have used both Memcache and Sqlite.

Arfeen · Accepted Answer · 2012-12-24 10:58:24Z

1

According to some research, forum discussions and analyzing the CDConnection and CActiveRecord code, it is confirmed that it must open a new connection. So either we write our code to avoid this or wait for a feature. Till than we can use data caching by saving the data object into cache.

answered Dec 24, 2012 at 10:58

Arfeen

2,6235 gold badges30 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

Yii: New DB connections when using CActiveRecord Cache

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related