I currently have a production website running version 1.9 and hosted on Personal Class ASP of Arvixe with SQL Server 2008. I only have approximately 300 products in my website but these past few months I noticed a lot of timeouts occuring randomly throughout the day when viewing my website. Looking at the logfile, the error is SQL Timeout. I noticed that if and when the SQL Timeouts are occuring, they only appear on the pages where the products table are being called via SQL whether it be on the back-end or the front-end. In other words, loading the manufacturers, categories, log file, and other tables load successfully but the product table triggers a timeout. After a few hours, the website loads fine again for all pages. I am assuming that the SQL Server is loaded and cannot, for one reason or another, accomodate any request containing the product table. Whether the stored procedure or the database schema containing the tables is not optimized I do not know since I never did look in the stored procedure of the database of version 1.9.
If I upgrade to version 2.5 using the same database content, will this create less stress on the SQL Server? Are the database schema and stored procedures a lot more optimized as compared to version 1.9? The additional features list in version 2.5 are really remarkable and kudos to the nopCommerce team for that, but as of the moment I actually can do without these added features. The main factor that would make me upgrade is more for optimization, faster loading times and hopefully less SQL Timeouts. Thanks in advance.