How to improve performance with Excel Add-ins on Custom object with VBCS

Summary:

Using Excel Add-ins on huge records for example 500,000 to 1,000,000 records on fusion custom object will give poor performance. Is there a way to use better way of computation to push the records after updating them.

Content (required):

Hi,

I have a user needs to update list of records of items. And in fusion there is a limited feature to do in bulk update.

I am going to use Excel Add-ins but I found references with bad and poor performance in such case.

Can VB gives more capability and use computing trick to do better performance. the records will be mostly between 500,000 and 1,000,000 records