Cakephp2 Application takes longer time to fetch data from sql server database resulting php memory error

[andola-dev]

Cakephp2 Application takes longer time to fetch data from sql server database resulting php memory error

[v-makouz]

What is the memory error? Also do you have a repro script?

[andola-dev]

What is the memory error? Also do you have a repro script?

Thanks @v-makouz. The memory error I am getting is Fatal error: Allowed memory size of 536870912bytes exhausted

I have just added the sqlsrv extension to php and copied the dll files to php ext folder
Also changed the database driver from mysql to mssql server
Then when I tried to connect to the mssql from the cakephp2 application, My application requires to fetch data from multiple tables
During this fetch I found the application is loading very slow and when I looked into the sql profiler I found lot of db connections are creating

[v-makouz]

Do you have a sample code I can use to try to reproduce this?