Hi,
I have updated our nop site to last version 4.6.06 and inserted 1 million of producuts in our store.
Daily we receive hundreds of errore like this:
Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
That coming from only 2 pages:
https://www.website.it/instantSearchFor?
and
https://www.website.it/search?
I can image that 1 million is an high number of records not for SQL Server .. but for nop? Dedicated server with SQL Server 2016 has 4 CPU and 16 GByte.
I discovered that timeout is 30 seconds but update the connection string adding ConnectTimeout=60 not produce any improvements of time; I will try to increase the command timeout but I'am not sure it is the best solution..
Any other suggestion to solve this bad issue?
Thanks in advance
BR
Massimo