> 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.
That seems to penalize the most common condition/use for the exceptional, which "rubs". I understand and agree that it would provide the best legacy support, without having to adding a "legacy mode" config setting. Sean ------------------------------------------------------------------------------ "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
