Welcome Guest, Not a member yet? Register   Sign In
SQLSRV fetch result is delaying
#1

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




Theme © iAndrew 2016 - Forum software by © MyBB