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.