Hello,
- For our activity, we need to create around 100 customized customer roles (one for each France department).
Our aim is to define customized tiers prices for each department.
- However, using this way, we noticed that the performance of our portal is really bad.
Checking in depth the SQL calls with a Profiler tool, it seems that the core model is sending one call per department, as soon as we reach a category page.
- This behavior is quite strange for us as we would have expected only 1 SQL call to get all the customer roles and not 1 query per role (so, 100 queries in our case)
- Another surprising fact is that it seems that the customer roles are not stored in the server cache.
- Both behaviors are impacting the SQL server and the global performance of the portal.
- Have you ever been informed of a such behavior please?
Could you please confirm us if there is any limitation using a specific number of customer roles?
Could you please also confirm us if there could be an easy way to at least store the roles in the server cache? updating a specific configuration in the BackOffice of the nopCommerce portal for example?
We are really looking forward to hearing from you. Any piece of advice would be really appreciated as our IT department is really suffering and impatient to have this issue solved...
Kind regards,
SBF
DBA - C# Senior Engineer