Hi,
I'm currently checking the CRT version of AM. And was thinking maybe it is a good option to use the hash of the value and the ChangedAt as ID value in the posit table. Then a lookup of the posit table in the trigger is not needed any more. This should speedup the inserts.
Also I'm checking if I can build the triggers without the extra table variable in the trigger. It takes a lot of time to fill the table variable in our setup.
Regards,
JJ.