Alexey Kukushkin created IGNITE-12826: -----------------------------------------
Summary: Poor JDBC Cache Store performance due to default fetch size Key: IGNITE-12826 URL: https://issues.apache.org/jira/browse/IGNITE-12826 Project: Ignite Issue Type: Bug Components: cache Affects Versions: 2.8 Reporter: Alexey Kukushkin Assignee: Alexey Kukushkin JDBC "fetchSize" parameter specifies the number of rows to be fetched from the database when additional rows are needed. For most drivers it is 10 by default. Larger fetchSize can significantly improve performance due to less network roundtrips (at expense of greater memory consumption). For some reason out-of-box JDBC POJO Cache Store uses default fetchSize in the loadCache method implementation. We have very poor loadCache performance when loading large amount of data from Oracle with the default fetchSize of 10. We tried setting fetchSize to 20K and that improved performance 40 times. We need to use JdbcDialect#fetchSize in the loadCache implementation so that users could implement a custom JdbcDialect to configure fetchSIze. -- This message was sent by Atlassian Jira (v8.3.4#803005)