prorm API Reference
    Preparing search index...

    Interface QueryOptimizationOptions

    Query optimization options

    interface QueryOptimizationOptions {
        enableHints?: boolean;
        enableExplain?: boolean;
        enableSlowQueryLog?: boolean;
        enablePreparedStatementCache?: boolean;
        enableQueryResultCache?: boolean;
        enableBatchOptimization?: boolean;
        slowQueryOptions?: Partial<SlowQueryOptions>;
        preparedStatementCacheOptions?: Partial<PreparedStatementCacheOptions>;
        queryResultCacheOptions?: {
            maxSize?: number;
            ttl?: number;
            logging?: boolean;
        };
        batchOptions?: Partial<BatchOptions>;
        explainOptions?: Partial<ExplainOptions>;
        logging?: (message: string, level?: "info" | "warn" | "error") => void;
    }
    Index
    enableHints? enableExplain? enableSlowQueryLog? enablePreparedStatementCache? enableQueryResultCache? enableBatchOptimization? slowQueryOptions? preparedStatementCacheOptions? queryResultCacheOptions? batchOptions? explainOptions? logging?
    enableHints?: boolean

    Enable query hints

    enableExplain?: boolean

    Enable explain plans

    enableSlowQueryLog?: boolean

    Enable slow query logging

    enablePreparedStatementCache?: boolean

    Enable prepared statement caching

    enableQueryResultCache?: boolean

    Enable query result caching

    enableBatchOptimization?: boolean

    Enable batch optimization

    slowQueryOptions?: Partial<SlowQueryOptions>

    Slow query logging options

    preparedStatementCacheOptions?: Partial<PreparedStatementCacheOptions>

    Prepared statement cache options

    queryResultCacheOptions?: { maxSize?: number; ttl?: number; logging?: boolean }

    Query result cache options

    batchOptions?: Partial<BatchOptions>

    Batch optimization options

    explainOptions?: Partial<ExplainOptions>

    Default explain options

    logging?: (message: string, level?: "info" | "warn" | "error") => void

    Logging function

    Settings
    Member Visibility

    On This Page
    Properties