> From: Carlos H. Cantu > In my ERP, I store some global configuration data in a config table. > In several triggers, I need to keep reading this config table to get > some values and use in IF's, etc. For batch operations, triggers will > be executed several times. A much better/efficient approach would be > to store some of the config data in session context variables, so > there would be no need to keep reading the config table every time.
We do exactly the same. Sometimes the config value is needed to evaluate for every row from set of tens/hundredes/thousand on some time-critical place, so without using context variables the customers would be angry. Moreover, not all context variables contain just value from simple config table, some require more complex evaluation, which again would be unacceptable to perform repeatedly on some places. I. ------------------------------------------------------------------------------ Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
