CodeIgniter Forums
SQLSRV Slow - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Development (https://forum.codeigniter.com/forum-6.html)
+--- Forum: Issues (https://forum.codeigniter.com/forum-19.html)
+--- Thread: SQLSRV Slow (/thread-68906.html)



SQLSRV Slow - rkb - 09-12-2017

We recently tried to upgrade from PHP 5.6 to PHP 7 and that involved using the sqlsrv driver. But it seems that this driver is really slow. I have searched for answers to the problem and one suggestion is to remove MARS on the connection string. In order to try this I would like to know how to do that with Codeigniter? Any other suggestions on how to over come the slow database query performance would be greatly appreciated.

Thank you.