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)
