schemaCachingDuration => 86400

Archives Yii 1.0.x Discussions
1

Hi,

I’ve set the ‘schemaCachingDuration’ to 86400, but there is still:

  • Querying SQL: SHOW COLUMNS FROM

  • Querying SQL: SHOW CREATE TABLE

in trace table.

In my controller:

Yii::app()->getDb()->schemaCachingDuration shows 86400

dbCache is disabled

Why is there the SHOW queries in the trace table?

2

You haven’t configured cache component.

3

ok, cache component is ready, I can see cache records in DB, but the trace table still shows the SHOW queries.

4

Yii has to run SHOW queries to cache the result, doesn’t it? I’m quite sure there is no meta data query since cache is set.

5

it works again.

I have used wrong config file.

Thanks.