On 1-5-2014 21:24, Leyne, Sean wrote: >> Optimization I. >> - VOLATILE (default) / DETERMINISTIC flag for UDF and FUNCTION (maybe >> lifecycle for deterministic : statement, transaction, connection) >> - gain : preformance (can cache DETERMINISTIC UDF/FUNCTION results) > > Actually, I think that with the exception of a random number generator, the > default for UDF should be DETERMINISTIC (Over 99% of UDFs are not volatile).
Given the way an optimizer could use this hint, it is better to be on the side of caution and require explicit declaration of DETERMINISTIC. Mark -- Mark Rotteveel ------------------------------------------------------------------------------ "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available. Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
