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. |