Total de postagens:
8
Karma:
40
Ingressou:
16/02/2010
Localização:
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
Total de postagens:
380
Karma:
5106
Ingressou:
11/12/2008
Localização:
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?
Total de postagens:
8
Karma:
40
Ingressou:
16/02/2010
Localização:
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
Total de postagens:
210
Karma:
1832
Ingressou:
16/03/2009
Localização:
Italy
Could you made a debug using source code? Then you see where crash it.
Total de postagens:
16619
Karma:
155940
Ingressou:
22/10/2008
Localização:
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
Total de postagens:
8
Karma:
40
Ingressou:
16/02/2010
Localização:
United States
Thanks for the reply, any chance of getting these changes in 1.8.