15.01.2017 19:00, Adriano dos Santos Fernandes wrote: > So what I call virtual metadata and how would it solve the problems: > > When a DDL command is issued, it will not change metadata directly. It > will change metadata in a memory structure tied to the current transaction. > > It may read metadata from database as needed and change it (in memory > structures). > > At commit time, changed metadata is validated (including validation with > dependencies) and changes are applied to database.
In fact, you are suggesting to create a new in-memory DBMS built into every transaction which collects all transaction changes and drop them into the main database on commit. It may work, but it will have all in-memory databases' disadvantages and is a very dramatic change in Firebird architecture. -- WBR, SD. ------------------------------------------------------------------------------ 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