| Subject | Re: [firebird-support] Re: Maintain Summary Table with Database Trigger |
|---|---|
| Author | unordained |
| Post date | 2010-07-23T20:59:22Z |
---------- Original Message -----------
From: "hvlad" <hvlad@...>
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.)
-Philip
From: "hvlad" <hvlad@...>
> Context variables are way better for such usage------- End of Original Message -------
> Regards,
> Vlad
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.)
-Philip