SQL Server - Time out Expired Problem(Help me)

hi everyone ,

                       I have  a table in sqlserver database which contains 15,00000( 1.5 crore record )
                        
                      and field are Registration No,CSC Code,Physical Code now I want to search record according to Registration number but when we enter Reg No. It take too much time to find that particular record .and throw a error 

(Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.)
Please provide me best solution for fast searching and also give me solution of (Timeout expired. )



Thanks & Best Record

ALOK RANJAN  

For this increase Timeout in web.config file-

 <system.web>
                <httpRuntime executionTimeout="value"/>
        </system.web>

If you don't want to timeout than just set Timeout = -1 in you command object than never time-out expire.

hi.. try the below

set the command TimeOut parameter to 0 , so that query executes till the end.

sqlComm.CommandTimeout = 0;

add the property in the connection string ConnectTimeout=120 in web.config

follow this steps.
---------------
Run –> Administrative tools –> Firewall –> Inbound rule–> Right click –> New rule –> Select port –> Click next –> Enter the SQL server port number –> Select the default –> Next –> Select the profile whatever you want –> Enter the name