Total de publicaciones:
8
Karma:
40
Unido:
16/2/2010
Ubicación:
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
Socio de solución de bronce
Total de publicaciones:
380
Karma:
5106
Unido:
11/12/2008
Ubicación:
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 publicaciones:
8
Karma:
40
Unido:
16/2/2010
Ubicación:
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 publicaciones:
210
Karma:
1832
Unido:
16/3/2009
Ubicación:
Italy
Could you made a debug using source code? Then you see where crash it.
Total de publicaciones:
16619
Karma:
155940
Unido:
22/10/2008
Ubicación:
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 publicaciones:
8
Karma:
40
Unido:
16/2/2010
Ubicación:
United States
Thanks for the reply, any chance of getting these changes in 1.8.