Anzahl der Beiträge:
8
Karma:
40
Beigetreten:
16.02.2010
Herkunft:
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
Anzahl der Beiträge:
380
Karma:
5106
Beigetreten:
11.12.2008
Herkunft:
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?
Anzahl der Beiträge:
8
Karma:
40
Beigetreten:
16.02.2010
Herkunft:
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
Anzahl der Beiträge:
210
Karma:
1832
Beigetreten:
16.03.2009
Herkunft:
Italy
Could you made a debug using source code? Then you see where crash it.
Anzahl der Beiträge:
16619
Karma:
155940
Beigetreten:
22.10.2008
Herkunft:
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
Anzahl der Beiträge:
8
Karma:
40
Beigetreten:
16.02.2010
Herkunft:
United States
Thanks for the reply, any chance of getting these changes in 1.8.