November Happy Hour will be moved to Thursday December 5th.

Commerce Manager - Contacts performance issue when metaObject maxListObject="xxxx" is increased to huge number.

Vote:
 

When there is many customers registered to the website, the commerce manager -> contacts tabs is default to display only the X no. of contacts as specified in the 

If the customers are more (ex: 50000+) then if we increase size in this config the contacts tab takes more time to load.

We are looking for some alternate solution to handle this without any performance drawback in commerce manager.

#188052
Feb 09, 2018 15:06
Vote:
 

Why do you want to show more than 50000 contacts?

#188121
Feb 12, 2018 17:40
Vote:
 

More than that, my site is growing day by day.

#188122
Feb 12, 2018 17:44
Vote:
 

That is normal, we have over 0,5M contacts. The question is why would you want to LIST more than 50000 of them at the same time?

#188123
Feb 12, 2018 17:46
Vote:
 

By default it shows 1000 customers (maxListObject). If we have more than that, the contacts tab will not show them all. So we need to increase the maxListObject object to some max value to suite website customers. 

Even if there is pagination, the moment we increased the maxListObject (to more than 50000 or 1M), the contacts tab is slow. 

#188124
Feb 12, 2018 17:50
Vote:
 

What use case do you have that requires the commerce manager to show all customers at once?

#188125
Feb 12, 2018 17:54
Vote:
 

We are not showing all customers at once. We view then page by page only. It shows only maximum of customers which is configured in maxListObject (ex:maxListObject  =1000, if 100 customers per page than it shows 10 pages. If we have 2000 customers it will not show the rest of the customers until i increase this config.). If we want client to access any customer beyond that limit, we need to increase this config which ends up in performance issue. Is that what expected from me?

#188126
Feb 12, 2018 18:34
Vote:
 

We will probably look into this, but I can't promise anything just yet. Big changes to the customer system will not be prioritized, but if I can find a small, "smart" way to solve the problem I might be able to sneak it into our releases, who know. 

Will keep you posted.

#188129
Feb 12, 2018 22:11
Vote:
 

Thanks Quan Mai

#188130
Feb 13, 2018 0:10
Vote:
 

As promised that I will keep you posted - this is happening. Today I made a breakthrough that actually works. Some polishing and clean up and a lot of test will be needed, but it might eventually make it in a upcoming release :) 

#197500
Oct 04, 2018 15:39
Vote:
 

Very Good news !! Thanks Quan!

#197785
Oct 12, 2018 17:02
Vote:
 

It will be released soon in Commerce 12.11 https://world.episerver.com/blogs/Quan-Mai/Dates/2018/10/new-paging-mechanism-for-business-foundation/

#198692
Nov 02, 2018 19:56
Vote:
 

Commerce 12.11 is available now on the Nuget server.

#198750
Nov 05, 2018 20:56
This thread is locked and should be used for reference only.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.