Is your feature request related to a problem? Please describe.
Currently, Indexer_CompanyList batch process involves deleting all records in single transaction and then re-adding the fetched data. Due to large size of the rsa_publickey data in company_list, this DELETE query can take a long time to execute, especially with a large number of company_list records.
Describe the solution you'd like
Modifying batch process to only delete unnecessary records, rather than performing a full deletion.
Is your feature request related to a problem? Please describe.
Currently,
Indexer_CompanyListbatch process involves deleting all records in single transaction and then re-adding the fetched data. Due to large size of thersa_publickeydata incompany_list, thisDELETEquery can take a long time to execute, especially with a large number ofcompany_listrecords.Describe the solution you'd like
Modifying batch process to only delete unnecessary records, rather than performing a full deletion.