[
https://issues.apache.org/jira/browse/IGNITE-9712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16631785#comment-16631785
]
Pavel Kuznetsov edited comment on IGNITE-9712 at 9/28/18 12:47 PM:
-------------------------------------------------------------------
Results on aws: 2 servers 1(2) clients, 4 threads
||Configuration ||Avg ops/sec||
|sql-select-pk-jdbc-thin-r1-1-backup |9,791.36|
|sql-select-pk-jdbc-thick-r1-1-backup |18,185.57|
|sql-select-pk-native-sql-r1-1-backup |18,578.95|
|Sql-select-val-jdbc-thin-r1-1-backup |9,371.92|
|Sql-select-val-jdbc-thick-r1-1-backup |16,147.76|
|Sql-select-val-native-sql-r1-1-backup |16,167.79|
|sql-select-pk-jdbc-thin-r1000-1-backup |3,107.89|
|sql-select-pk-jdbc-thick-r1000-1-backup |3,897.32|
|sql-select-pk-native-sql-r1000-1-backup |4,132.67|
|Sql-select-val-jdbc-thin-r1000-1-backup |2,837.67|
|Sql-select-val-jdbc-thick-r1000-1-backup |3,392.78|
|Sql-select-val-native-sql-r1000-1-backup |3,689.99|
was (Author: pkouznet):
Results on aws: 2 servers 1(2) clients
||Configuration ||Avg ops/sec||
|sql-select-pk-jdbc-thin-r1-1-backup |9,791.36|
|sql-select-pk-jdbc-thick-r1-1-backup |18,185.57|
|sql-select-pk-native-sql-r1-1-backup |18,578.95|
|Sql-select-val-jdbc-thin-r1-1-backup |9,371.92|
|Sql-select-val-jdbc-thick-r1-1-backup |16,147.76|
|Sql-select-val-native-sql-r1-1-backup |16,167.79|
|sql-select-pk-jdbc-thin-r1000-1-backup |3,107.89|
|sql-select-pk-jdbc-thick-r1000-1-backup |3,897.32|
|sql-select-pk-native-sql-r1000-1-backup |4,132.67|
|Sql-select-val-jdbc-thin-r1000-1-backup |2,837.67|
|Sql-select-val-jdbc-thick-r1000-1-backup |3,392.78|
|Sql-select-val-native-sql-r1000-1-backup |3,689.99|
> SQL: Select query benchmarks suite
> ----------------------------------
>
> Key: IGNITE-9712
> URL: https://issues.apache.org/jira/browse/IGNITE-9712
> Project: Ignite
> Issue Type: Task
> Reporter: Pavel Kuznetsov
> Assignee: Pavel Kuznetsov
> Priority: Major
>
> We need to create benchmark suite for select operations.
> We already have benchmarks for selects, so we need to update this code to
> support
> 1) select the single row with by PK; indexed field
> 2) select the range of rows filtered with PK; indexed field
> Selects by non-indexed fields are out of scope.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
