[IGNITE-11894] Add fetchSize to JDBC cache stores

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Fix Version/s: 2.9
• Component/s: cache
• Labels: newbie
• Ignite Flags: Docs Required
• Assignee: Amit Chavan
• Reporter: Stanislav Lukyanov
• Created: 05/Jun/19 00:30
• Updated: 05/Aug/20 08:22
• Resolved: 28/Mar/20 09:22

Description

JDBC's PreparedStatement accepts a fetchSize parameter which defines how many rows will be loaded from the DB at a time. Currently the only way to change that is by specifying it in a custom implementation of the JdbcDialect::fetchSize method (and even then it seems not be be used in some cases).

Would be good to have a fetchSize property in all of JDBC-based cache stores.

Issue Links

• duplicates: IGNITE-12826 Poor JDBC Cache Store performance due to default fetch size