Unanswered: Informix CDC API starts extremely slowly
Hi, I wrote a C application to read CDC records from Informix logical log using CDC API. It starts a CDC session from an existing LSN where many CDC records alsredy exist, and reads them using ifx_lo_read().
Unfortunately, ifx_lo_read() returnds CDC_REC_TIMEOUT many times, for 3-5 minutes !), until it returns the first CDC records.
However, if the application executes EXEC SQL CREATE TEMP TABLE DUMMY(id integer),
then ifx_lo_read returns the CDC records immediately with no delay.
I tried other EXEC SQL commands, but they do not shorten the delay.
My application will be installed on customer sites who will not like the idea that it creates tables on their production DB, not even temp tables.
Can anyone explain what causes the delay and why creating a temp table prevents it, and how I can shorten the delay without this workaround?