+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: SQLSRV fetch result is delaying (/showthread.php?tid=31146)
SQLSRV fetch result is delaying - El Forum - 06-08-2010
[eluser]Tamilmani[/eluser]
I am using "sqlsrv" dbdriver . When i compiled the simple query . It will take more time to fetch the result . Is there any problem is sqlsrv diver ??
My Code
Code:
countries table . In this tablle i have 241 records(country_id, country_name)
$query = $this->db->get('countries');
if($query->num_rows() == 0){
return '';
}else{
return $query->result();
}If i used above code . I am getting the result after 300 seconds. Sometimes max time is also exceed . So what to do for this situation? Any suggestion Please ?