API Reference > imodeljs-backend > ECSQL > ECSqlStatementCache ECSqlStatementCache Class A cache for ECSqlStatements. Preparing ECSqlStatements can be costly. This class provides a way to save previously prepared ECSqlStatements for reuse. Both IModelDbs and ECDbs have a built-in ECSqlStatementCache. So normally you do not have to maintain your own cache. Methods Name Description constructor(maxCount: number = Config.App.getNumber("imjs_ecsql_cache_size", 40)): ECSqlStatementCache add(str: string, stmt: ECSqlStatement): void clear(): void find(str: string): CachedECSqlStatement | undefined getCount(): number release(stmt: ECSqlStatement): void removeUnusedStatementsIfNecessary(): void replace(str: string, stmt: ECSqlStatement): void Properties Name Type Description maxCount number Defined in core/backend/src/ECSqlStatement.ts Line 970 Last Updated: 13 June, 2024