Всего сообщений:
8
Карма:
40
Присоединился:
16.02.2010
Страна:
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
Bronze-партнер по запуску магазинов
Всего сообщений:
380
Карма:
5106
Присоединился:
11.12.2008
Страна:
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?
Всего сообщений:
8
Карма:
40
Присоединился:
16.02.2010
Страна:
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
Всего сообщений:
210
Карма:
1832
Присоединился:
16.03.2009
Страна:
Italy
Could you made a debug using source code? Then you see where crash it.
Всего сообщений:
16619
Карма:
155940
Присоединился:
22.10.2008
Страна:
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
Всего сообщений:
8
Карма:
40
Присоединился:
16.02.2010
Страна:
United States
Thanks for the reply, any chance of getting these changes in 1.8.