Clicking "Import Contacts" button in the Contact Management module is too much slow.

Gurupada Giri asked on April 24, 2024 17:59

Clicking "Import Contacts" button in the Contact Management module is too much slow, taking approx 30 Second to load.

In the Contact Module in the "OM_Contact" table, we have 155055 records, size of the "OM_Contact" table is 284MB.

Our sites are deployed in the Azure and Pricing Tier is Premium P2V3, So we are using enough resource and already did the DB Indexing but the issue didn't resolve.

Please suggest how to resolve the issue.

Recent Answers


Brenden Kehren answered on May 2, 2024 15:39 (last edited on May 2, 2024 15:40)

What tier is your database running at? Your database may be the bottleneck. I'd suggest temporarily scaling up your database tier to something very high to perform that import, then scale it back down after your import is complete.

If you have segments that run automatically or on a scheduled basis, that processing will run as needed when those contacts are imported so there could be some additional processing that's happening in the background that could be causing the slowness.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.