AnsweredAssumed Answered

Mass update of a single field takes ages..

Question asked by Hugo Geyskens on Apr 16, 2019
Latest reply on May 10, 2019 by B_Canales

Hi there,

As keyuser/admin, I'm asked to do several mass updates on our contact and opportunity records.

An average mass update request is involving about 10,000 records.

However, Sugar only seem to work in chunks of 1000 records ? (although the configuration doesn't show an entry in the max records field which is empty so should be limitless ?).

Also, if you feed Sugar a file of 1000 updates, if at all it reaches the end before aborting for various reasons, it takes ages to complete (about an hour upto an hour and a half for those 1000 record chunk...)

Is there something I can do to speed up things ? Configuration parameters to adapt ? Using a differen approach instead of the mass update function ?

We have various roles (admins, key users, regular users) in Sugar all experiencing the same...

Anybody else experiencing this extreme slow mass upgrade function ?


Thanks !