Hash as ID of the Posit table

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

Hash as ID of the Posit table


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.