Posted on 01/07/2025 10:24:13
Hi Davy
Not really. Depending on how you look at it - and define as bad performance.
4000 products in one go would produce a very large output in markup - that alone would be potentially expensive as it would need to repsond with a large amount of data. Looking up 4000 prices in BC would also require 2 things - a lot of communication to BC and for BC to make a lot of calculations. And BC will take time doing that and the amount of data send from DW to BC and back would also cost some execution time.
2000 customers is a lot - so if you generate all of it in one go, it would be 8.000.000 price calculations and product renders - and that would be a problem. If it is on demand, it depends on how you distribute the load - if many customers do it in one go, or the load is distributed over a lot of time.
DW10 would be vastly faster. Using the coming OData live would also be faster than the current webservice approach - just because the amount of data back and forth is much smaller.
Can you ellaborate on the use case?
You want your customers to generate a 4000 product product catalog and be saved as static? or what is the use case?
The idea of a online always up-to-date system is to not create static long catalogs that are out of date in just 2 seconds. Maybe the use case can be rethought?
BR Nicolai
