Firebird Configuration, episode 2: TempCacheLimit
This video is devoted to TempCacheLimit, one of the key parameters for performance of queries with large sortings (i.e., those with ORDER BY, GROUP BY, DISTINCT, UNION, etc).
Presentation from the video is here: https://ib-aid.com/download/docs/2024...
Configuration Calculator for Firebird: https://cc.ib-aid.com/democalc.html
Episode 1 - The biggest configuration error in Firebird SQL (Errors with DefaultDBCachePages and ServerMode): • The biggest configuration error in Firebir...
Episode 2 (this video) - TempCacheLimit • Firebird Configuration, episode 2: TempCac...
Episode 3 - InlineSortThreshold and details of sorting • Firebird Configuration, episode 3: InlineS...