21.08.2015 14:26, 'Louis van Alphen' wrote: > When I have a master with lookup as described; and many rows from the master > table reference the same lookup row, is the lookup row cached after the first > read or is it read for every master table row that refers to it. If I look at > the diagnostic tools I use, it seems to be the latter. If the case, also very > inefficient and expensive
Firebird never caches records. However, data pages containing lookup rows will be cached inside the buffer cache. Dmitry
