>>>When running the site with SQL Server, I have found that the access to certain tables will take longer at first because the tables haven't been accessed yet. So, at first, it may take a little bit longer to process the hit. So, on big tables, I might end up with a Timeout expired message. I need to increase that in the database. Where can I go to adjust that?
>>
>>Use ConnectTimeout or Connection Timeout keywords in the connection string. Something like this:
>>
>>string myConnectionString = "Data Source=(local);Initial Catalog=AdventureWorks;Integrated Security=SSPI;Connection Timeout=30";
>>
>
>I think the connection timeout only relates to the time taken to obtain the connection......
Interesting, I didn't know that.
Semper ubi sub ubi.