[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 ?