Subject Re: [firebird-support] Re: Maintain Summary Table with Database Trigger
Author unordained
---------- Original Message -----------
From: "hvlad" <hvlad@...>
> Context variables are way better for such usage
> Regards,
> Vlad
------- End of Original Message -------

Context variables are limited to 1000 entries per context (CORE-3027), no? Global
temporary tables aren't so limited, can be indexed, constrained, and are easier
to loop and join over, for batch updates. And in my testing, putting items to do
"later" in a temporary table felt no slower than putting them into context
variables. (It sure felt like context variables were just another temporary
table, hidden, but maybe I was just testing that horribly wrong.)