On 01/03/2017 01:17, Dmitry Yemanov wrote: > 01.03.2017 00:18, Dmitry Kuzmenko wrote: >> As to BLR, I don't think that eliminating BLR is a good idea. You need >> to have same or better speed of interpreting SQL > Execution time does not depend on whether it's BLR or SQL. Parsing time > (read: prepare time) depends. > > A major parse time (parsing text instead of BLR) will reflect in execution time of first execution and execution after metadata changes.
What I agree it does not make sense currently: on demand (not stored) SQL query -> BLR -> nodes, instead of: on demand SQL query -> nodes. SQL standard also says that when one uses "select * from", asterisk expansion should be done in the moment the command is issued, not at execution time. A pure stored-SQL engine will violate this rule. Adriano ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
