ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Igor Sapego (Jira)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client
Date Wed, 20 Nov 2019 10:37:00 GMT

    [ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16978298#comment-16978298

Igor Sapego commented on IGNITE-12374:

[~yow] I checked out the sample code and I have a feeling that performance drop may be related
to atol and atof calls in sql_set_parameter. Need to check this though

> Too low performance ~200TPS for single ODBC client
> --------------------------------------------------
>                 Key: IGNITE-12374
>                 URL: https://issues.apache.org/jira/browse/IGNITE-12374
>             Project: Ignite
>          Issue Type: Improvement
>          Components: clients, odbc
>    Affects Versions: 2.7.5
>         Environment: Ignite server run on top of Kubernetes, with 2 server nodes, persistence
enabled. Both CPU and RAM at server/client server is sufficient according to system reports.
>            Reporter: swy
>            Priority: Major
>         Attachments: odbcsample.cc, values.yaml
> Hi, in our test ignite performance with ODBC connection is too bad to proceed with product
integration. It is about ~200 TPS, each transaction with select+update operation.
> Please refer to attach sample program. It is just a simple test case. 
> Based on the profiling most of the time consumed by sql execution. Please advice if the
application did not do the right thing.
> Thank you.
> g++ -I/usr/include -I./ignite/binary/include -I./ignite/common/include -I./ignite/common/os/linux/include
-I./ignite/common/os/win/include -I./ignite/core/include -I./ignite/jni/include odbcsample.cc
-o odbcsample -lodbc -L./ignite-libs/libignite.so -L./ignite-libs/libignite-odbc.so

This message was sent by Atlassian Jira

View raw message