How To Understand If Apc And Db Schema Caching Is Working ?

Yii 1.1 General Discussion
1

My PHP now has got APC. Configured and running.

So I added this to main.php




'apcCache' => array (

             'class' => 'CApcCache',

        )

And I added this lines to ‘db’ components definition




'queryCacheID'          => 'apcCache',

'schemaCachingDuration' => 3600,

Now, How can I understand if schema caching is really working ?

If i enable CDbCommand log, i can see query like this




SHOW FULL COLUMNS FROM `sms_client`

SHOW CREATE TABLE `sms_client`

At every refresh, this query (looks like) has been re-executed.

How can i detect when a query is take-off from cache and when not ?

2

CDbConnection::schemaCacheID

queryCacheID is for caching, you guessed it, queries.

3

Thanks for note, I’ll correct this. …