On 10/02/2022 07:36, Dimitry Sibiryakov wrote: > Alex Peshkoff via Firebird-devel wrote 10.02.2022 10:59: >>> If\when shared metadata will be implemented - will it be possible to >>> use cached compiled statement created in one attachment to use by >>> another >>> attachment ? >> >> If we need to take roles into an account - only for attachment with >> same USER. > > It depends on what exactly is going to be cached. If only execution > plan is cached - it is not affected any by current user, any by role. >
Every DSQL structure (messages structures, for example) is cached. (Jrd)Statement is reused - new jrd_req are get from same statement. Things related with the DSQL request (message buffers) are created for each request. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel