[IGNITE-12374] Too low performance ~200TPS for single ODBC client

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Information Provided
• Affects Version/s: 2.7.5
• Component/s: clients, odbc

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.

• Assignee: Unassigned
• Reporter: swy
• Created: 15/Nov/19 01:50
• Updated: 12/Dec/19 03:10
• Resolved: 12/Dec/19 03:09

Description

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.

local ignite server, but the result same to remote container Ignite deployment too.

cat /etc/apache-ignite/my-config.xml

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd">

    <bean id="ignite.cfg" class="org.apache.ignite.configuration.IgniteConfiguration">
        <property name="clientConnectorConfiguration">
            <bean class="org.apache.ignite.configuration.ClientConnectorConfiguration"/>
        </property>
        <property name="binaryConfiguration">
            <bean class="org.apache.ignite.configuration.BinaryConfiguration">
                <property name="compactFooter" value="false"/>

                <property name="idMapper">
                    <bean class="org.apache.ignite.binary.BinaryBasicIdMapper">
                        <property name="lowerCase" value="true"/>
                    </bean>
                </property>
            </bean>
        </property>
    </bean>
</beans>

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