Hello Group,

I am looking at a situation where lots of different stored procedures need to execute an alternate query where a certain condition is true in the database.

I would normally do something along the lines

IF (EXISTS(SELECT 1 FROM CONFIG WHERE CONFIGID = 1234 AND VALUE=1)) THEN
BEGIN
  -- Do alternate query
END
ELSE
BEGIN
  -- Do usual query
END

ConfigID is a primary key, so it is already quite efficient, but I am interested in whether it is even more efficient if I was to use RDB$GET_CONTEXT.

For example, when I establish the connection, I could do something like

IF (EXISTS(SELECT 1 FROM CONFIG WHERE CONFIGID = 1234 AND VALUE=1)) THEN
BEGIN

  rdb$set_context('USER_SESSION', 'Config1234', '1');

END

And then I can refer in my various stored procedures

IF ((RDB$GET_CONTEXT('USER_SESSION', 'Config1234')=1) THEN

BEGIN
  -- Do alternate query
END
ELSE
BEGIN
  -- Do usual query
END

I should note that the flag I am talking about is static for the duration of these connections, so there is no logical difference in this behaviour.

So my question is whether there would be any possible improvement in performance from this (or whether for example the context variables are internally stored in a table anyway and so it is at best the same)?

Thanks

Adam