Interface MultiKeyLoadSizingStrategy

  • Functional Interface:
    This is a functional interface and can therefore be used as the assignment target for a lambda expression or method reference.

    public interface MultiKeyLoadSizingStrategy
    Strategy for determining an optimal size for loading by multiple keys. The optimal size is defined as the most appropriate number of key values to load in any single SQL query.
    See Also:
    Dialect.getMultiKeyLoadSizingStrategy(), BatchSize, Session.byMultipleIds(java.lang.Class<T>), Session.byMultipleNaturalId(java.lang.Class<T>)
    API Note:
    This is used with IN-list style loading to determine the number of keys to encode into the SQL restriction to make sure we do not exceed database/driver limits on the number of JDBC parameters. Generally, prefer using a SQL ARRAY parameter for the keys instead if the database/driver supports it.
    • Method Detail

      • determineOptimalBatchLoadSize

        int determineOptimalBatchLoadSize​(int numberOfKeyColumns,
                                          int numberOfKeys,
                                          boolean inClauseParameterPaddingEnabled)
        Determine the optimal batch size (number of key values) to load at a time.

        The return can be less than the total numberOfKeys to be loaded indicating that the load should be split across multiple SQL queries. E.g. if we are loading 7 keys and the strategy says the optimal size is 5, we will perform 2 queries.

        numberOfKeyColumns - The number of columns to which the key is mapped
        numberOfKeys - The total number of keys we need to load
        inClauseParameterPaddingEnabled - See QuerySettings.IN_CLAUSE_PARAMETER_PADDING
        The number of keys to load at once. The total number of JDBC parameters needed for that load is defined by numberOfKeys * numberOfKeyColumns. The strategy should take care to ensure that numberOfKeys * numberOfKeyColumns does not exceed any database/driver limits on the number of parameters allowed in a PreparedStatement.
        API Note: