Tổng Bài đăng:
8
Karma:
40
Đã tham gia:
16/02/2010
Vị trí:
United States
Hi, Has anyone tried nop with 1.5 million or more products. After populating 1.5 million products I get SQL timeout error on displaying product page. This is the error I get: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Admin Product Display also throws the same error. Regards, Hunaid
Đối tác giải pháp hạng đồng
Tổng Bài đăng:
380
Karma:
5106
Đã tham gia:
11/12/2008
Vị trí:
Singapore
i remember nop team has mentioned there could be some performance issue if products > 1million, when the version was 1.4. which version are you using?
Tổng Bài đăng:
8
Karma:
40
Đã tham gia:
16/02/2010
Vị trí:
United States
I am using version 1.7, SQL 2008 R2, IIS 7 and Operating System is Windows 2008 R2. My server has 4 GB of memory. Regards, Hunaid
Tổng Bài đăng:
210
Karma:
1832
Đã tham gia:
16/03/2009
Vị trí:
Italy
Could you made a debug using source code? Then you see where crash it.
Tổng Bài đăng:
16619
Karma:
155940
Đã tham gia:
22/10/2008
Vị trí:
Armenia
I think nopCommerce cannot handle 1.5 million products now (we're working on performance optimization). Presume that the issue is with [Nop_ProductLoadAllPaged] stored procedure that needs to be optimized. And a some of other minor performance issues on backend pages
Tổng Bài đăng:
8
Karma:
40
Đã tham gia:
16/02/2010
Vị trí:
United States
Thanks for the reply, any chance of getting these changes in 1.8.