Hey people, I am studying a situation where the connection has no data to load using CDC do capture data. Looks to me when has no new data to get, the process stay waiting few minutes to get something and this process expend more time then a situation that has few record to load. Is possible to configure this wait?
I need to build a process that replicate data near real time. Few record can be replicated few more than 1 minute, but, if have no records, during at least 5 minutos. I am thinking in schedule to run every minute and I expected when has no data that processes finishes faster then when have records.