In most cases, the data in the primary table can be synchronized within 10 seconds, whereas data synchronization in secondary tables takes longer. Real-time synchronization cannot be achieved.
If both the primary and secondary tables contain data to be updated, we recommend that you first update secondary tables and then the primary table. You can refresh the primary table data to update the secondary table data and the indexes. This reduces the data synchronization duration.
Alternatively, you can wait for one second after the secondary table data is updated. Then, you can search for the primary table data in the source data based on the updated data in the secondary tables, and update the primary table data.
If the issue persists, submit a ticket to request technical support.