MS SQL Time Out

This topic is locked

MS SQL Time Out	8/1/2011 5:28:47 AM
PHPRunner General questions
hfg author When trying to use the advanced search we are the following error after 30-60 seconds (it is not consistent) Error 256 Source: Microsoft OLE DB Provider for SQL Server Description: Timeout expired I have tried changing timeout settings in the code and the php.ini file, neither worked. Any advice or troubleshooting steps would be appreciated


	Sergey Kornilov admin 8/1/2011
	The best approach is to add required indexes to the database in order to speed up searches. Nobody wants to wait for the whole minute to see results. SQL Server timeout needs to be configured in SQL Server itself.