Currently, all entities are replicated by selecting all the entries from Electra DB and upsert them in OpenCart DB.
Will be better if we implement delta replication - replicate only the newly added or modified entries.
This could be achieved with a configuration which stores the timestamp of the last replication.
Next time the replication is triggered, we will get only the entries which are modified (date_modified column) after the timestamp which is stored in the config from the previous run.
Currently, all entities are replicated by selecting all the entries from Electra DB and upsert them in OpenCart DB. Will be better if we implement delta replication - replicate only the newly added or modified entries. This could be achieved with a configuration which stores the timestamp of the last replication. Next time the replication is triggered, we will get only the entries which are modified (
date_modified
column) after the timestamp which is stored in the config from the previous run.depends on: https://github.com/eclipse/dirigible/issues/3509