Why Is My Sync Slow or Delayed?
Question
Why is my sync slow or delayed?
Environment
Connector: NetSuite SuiteAnalytics
Answer
Once a week, we re-import large tables that take more than 60 minutes to ingest, during which you may experience a longer sync time than usual. For the list of applicable tables, see our NetSuite SuiteAnalytics re-import documentation.
In addition, to detect deleted records, we divide tables into contiguous chunks and re-import the chunks for which we detect change. If you have modified or deleted many records, we may need to re-import more tables than usual, impacting your sync time. For the list of applicable tables, see our NetSuite SuiteAnalytics data deletion documentation.
In the LOG
table of the Fivetran Platform Connector, you can check the number of records_modified
events reflected for each applicable table to determine whether the above strategies impacted your sync.