Yii Mssql Connection - Autoclose False

Yii 1.1 General Discussion
1

I am using Yii with MSSQL 2008 R2. The database has the setting Autoclose set to False. However, I am still encountering that the first connection made when no open connections exist is taking a lot of time.

I am therefore wondering if there is any setting in Yii which may affect the Autoclose feature?

Or do you have any other ideas of why the first connection would take such a long time to start up otherwise?

2

Can anyone help out?

3

If anyone encounters the same issue, this was solved by creating a scheduled job which queries the db with a simple query every 30 minutes. It’s strange though that this happens considering that auto close is set to off.