sql server - sqlsrv drivers slow in codeigniter? -
i have installed latest version of ci 2.1.3 now after running query, getting slow response time simple such as: function bash(){ $sql = “select * contacts”; $stmt = sqlsrv_query( $conn, $sql ); if( $stmt === false) { die( print_r( sqlsrv_errors(), true) ); } after querying remote database. (sql server 2008) when run same query in simple php script against same remote database. results instantly. a) has else experienced problem sqlsrv drivers in codeigniter? if so, how did solve it? here connection string: $db['default']['hostname'] = "xxxxx,1433"; $db['default']['username'] = "xx"; $db['default']['password'] = "xxxxxx-xx"; $db['default']['database'] = "xxxxxxxxx"; $db['default']['dbdriver'] = "sqlsrv"; $db['default']['dbprefix'] = ''; $db['default']['pconnect'] = true; $db['default']