I am new with CDC (Change Data Capture). We have to process 16 million transaction per minute. We are using IBM Informix for DB.
My task is to add a feature of storing current transaction id to some resources either File, DB etc. and an API will use this transaction id as a previous transaction id and start from the next transaction id. But storing to File or DB will not be an option as these are very heavy operations writing in a file or DB.
Is there any other way to resource to store previous transaction id to improve API efficiency.
We are using Java.