[
https://issues.apache.org/jira/browse/IGNITE-3628?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15449685#comment-15449685
]
Igor Sapego edited comment on IGNITE-3628 at 8/30/16 6:02 PM:
--------------------------------------------------------------
Completed benchmark. Got following results:
{noformat}
Default page size (32), no network delay: 25893
operations/second.
Default page size (32), 2 ms network delay emulation: 5379
operations/second.
Adjusted page size (1024), no network delay: 28011
operations/second.
Adjusted page size (1024), 2 ms network delay emulation: 24691
operations/second.
{noformat}
Now I'm going to set default value to 1024 and add corresponding connection
argument, so user can adjust it during connection.
was (Author: isapego):
Completed benchmark. Got following results:
{noformat}
Default page size (32), no network delay: 25893
operations/second.
Default page size (32), 2 ms network delay emulation: 5379
operations/second.
Adjusted page size (1024), no network delay: 28011
operations/second.
Adjusted page size (1024), 2 ms network delay emulation: 24691
operations/second.
{noformat}
> ODBC: Improve data fetching performance.
> ----------------------------------------
>
> Key: IGNITE-3628
> URL: https://issues.apache.org/jira/browse/IGNITE-3628
> Project: Ignite
> Issue Type: Task
> Components: odbc
> Affects Versions: 1.6
> Reporter: Igor Sapego
> Assignee: Igor Sapego
> Labels: important, odbc, performance
> Fix For: 1.8
>
>
> Need to add some kind of benchmark to be able to measure fetching performance
> of the ODBC driver, then profile it and improve performance where it is
> possible. Pay attention to the fetching page size.
> Consider adding "Fast first row" feature.
> Consider adding {{FETCH_PAGE_SIZE}} connection argument.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
