Slow SQLRV Fetch Results . Any Suggestion Please ?

Jun 26, 2010 at 6:56 PM

Hi All,

I am working with PHP Azure Solution with Microsoft Sql Server . I have written the code in PHP Framework (Codeigniter) and i used sqlsrv driver to connect the microsoft sql server .

If less than 10 - 15 records in database table. It can easily fetch the result . But more than 15 records , it will take more time to fetch the result .It shows timeout error message . foreach loop is used to fetch the result .

Any suggestion please.


Tamilmani Mohan