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