CodeIgniter Forums
SQLSRV Slow - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Development (https://forum.codeigniter.com/forumdisplay.php?fid=6)
+--- Forum: Issues (https://forum.codeigniter.com/forumdisplay.php?fid=19)
+--- Thread: SQLSRV Slow (/showthread.php?tid=68906)



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.