FetchSize of the JdbcStore

[Nikolay Izhikov-2]

Hello, Igniters.

Right now there is no way for the user to set fetchSize of the JdbcStore
This leads to the poor performance of the cache load with the 3-d party persistence [1]

I propose to add JdbcDialect#setFetchSize method [2]

Thoughts?

[1] https://issues.apache.org/jira/browse/IGNITE-12826
[2] https://github.com/apache/ignite/pull/7577/files

[Ivan Pavlukhin]

Hi Nikolay,

There is a very similar ticket [1]. Perhaps it could be somehow useful.

[1] https://issues.apache.org/jira/browse/IGNITE-11894

Best regards,
Ivan Pavlukhin

чт, 26 мар. 2020 г. в 17:54, Nikolay Izhikov <[hidden email]>:

>
> Hello, Igniters.
>
> Right now there is no way for the user to set fetchSize of the JdbcStore
> This leads to the poor performance of the cache load with the 3-d party persistence [1]
>
> I propose to add JdbcDialect#setFetchSize method [2]
>
> Thoughts?
>
> [1] https://issues.apache.org/jira/browse/IGNITE-12826
> [2] https://github.com/apache/ignite/pull/7577/files

[Nikolay Izhikov-2]

Hello, Ivan.

Yes, this is the same issue.
I will proceed with this improvement if there is no objections.

чт, 26 мар. 2020 г., 19:40 Ivan Pavlukhin <[hidden email]>:

> Hi Nikolay,
>
> There is a very similar ticket [1]. Perhaps it could be somehow useful.
>
> [1] https://issues.apache.org/jira/browse/IGNITE-11894
>
> Best regards,
> Ivan Pavlukhin
>
> чт, 26 мар. 2020 г. в 17:54, Nikolay Izhikov <[hidden email]>:
> >
> > Hello, Igniters.
> >
> > Right now there is no way for the user to set fetchSize of the JdbcStore
> > This leads to the poor performance of the cache load with the 3-d party
> persistence [1]
> >
> > I propose to add JdbcDialect#setFetchSize method [2]
> >
> > Thoughts?
> >
> > [1] https://issues.apache.org/jira/browse/IGNITE-12826
> > [2] https://github.com/apache/ignite/pull/7577/files
>