Daniel Sonda

The current generic memory cache serialize objetcs to JSON, but I'd like to store the object itself, like a TDictionary. Are there some way to do this?

Using exists in Firebird 5.0.1 uses a different and slow plan compared to just the select statement

6

Given the query below: ```sql SELECT IIF(EXISTS( SELECT ORDEM_PRODUCAO.ORP_ID FROM ITEM_SEPARACAO_PEDIDO_VENDA INNER JOIN ORDEM_PRODUCAO ON (ITEM_SEPARACAO_PEDIDO_VENDA.ISP_ID = ORDEM_PRODUCAO.ISP_ID) WHERE (ITEM_SEPARACAO_PEDIDO_VENDA.IPV_ID = 9437253)), 'Sim', 'Não') as TEM_OP FROM RDB$DATABASE ``` All...

Given the query below: ```sql SELECT ITEM_NOTA_COMPRA.INC_ID FROM ITEM_NOTA_COMPRA LEFT JOIN NOTA_COMPRA ON (ITEM_NOTA_COMPRA.NTC_ID = NOTA_COMPRA.NTC_ID) WHERE (ITEM_NOTA_COMPRA.INC_ID_COMPLEMENTADO = 651321) AND (NOTA_COMPRA.NTC_SITUACAO = 'Finalizada') ``` Field INC_ID_COMPLEMENTADO is a foreign...