long response time on first query to db table

Yii 1.1 General Discussion
1

I have a strange behaviour in my application: when I display the contents of a oracle table in a CGridView (using a CActiveDataProvider), the response time of the first request is very long, about 10 seconds.

All the following requests to the same table are quick after this.

I suspect there is some cache being built up but I cannot figure where: the problem does not appear after a restart of the apache server, and it does not show when I use a second browser session.

Can anybody give me a hint? sorry for the probably stupid question, but I am a relative yii newbie.

2

Oracle is probably maintaining its own query cache.

3

when I query the same tables with a perl script I dont see the same behaviour