I agree with you both but your not hearing what I am saying.
We are running on a VPS with SQL Server 2008 R2 and plenty of ram.
The front end( the web store itself runs fine. Very fast and you can see it here)
www.nyrpcorp.comWe just upgraded from 2.8 to 3.1 last Friday.
2.8 actually did have issues for us due to fly-out menu support and the fact that we have 3000 categories that needed to be cached every time a category was created or updated (30 second lag time to rebuild the categories after category edit). That issue is similar to the issue we are having now but that was on categories not products and due to the fly-out menu support in 2.8. That issue was fixed with a mod someone gave us that took the category structure back to 2.65 version. this issue was corrected in 3.0 by removing fly-out menu support. We are having no issues now with categories.
Our issue is on Products in admin panel only. 30 second lag time to create, edit or save a product. We have 13,000 products. We had no issues with products in version 2.8. IMO something with the way the new product structure(combining the Product with the Product Variant and calling it all at once) is causing the problem on a store with a large catalog. I have viewed the nop demo site and yes it works fine but that storefront only has 54 products in it. nopcommerce should put 10,000 products in the demo store to see if the structure can actually handle a catalog that large.
I have already created a fresh copy of 3.1(out of the box) and wired it up to a back up of our 3.1 database and the problem persists. Today i will be creating another 3.1 out of the box but on this one I will be configuring it with the data built into the store out of the box. So it will be truly out of the box install. I am then going to import 10,000 products into it. If the problem persists then nopcommerce 3.1 cannot handle 10,000+ products out of the box. If there is no problem then it is related to my store and my code.