Hi Stan The result will be the same without transaction, even with atomic mode. So wondering if there is other reason capped the performance. Attach is our POC source code which give around 1700 TPS, with or without transaction, may be you can advise what's wrong with it.
-DIGNITE_MAX_INDEX_PAYLOAD_SIZE=64 is using already. We choose ODBC because it is more compatible to existing product's API, which will need to create table/cache on the fly without pre-define C-object. Ignite C++ need to have the cache C-object ready before run. Also in Ignite cluster, how can we connect to cluster, just connect to one of the host? And when host crash we need to change manually connect to another node? Seems ODBC connection string not allow to input multiple host address. Thanks in advance. Regards, Yow ________________________________ From: Stanislav Lukyanov <stanlukya...@gmail.com> Sent: Wednesday, November 6, 2019 12:33 AM To: user@ignite.apache.org <user@ignite.apache.org> Subject: Re: Ignite singel instance First, 1700 TPS given your transaction structure is 170000 simple operations per second, which is quite substantial - especially if you're doing that from a single thread / single ODBC client. Second, note that TRANSACTIONAL_SNAPSHOT is in beta and is not ready for production use. There are no claims about performance or stability of that cache mode. Third, you don't need the index on key01 - it is created automatically because it is a primary key. But you do need to set INLINE SIZE of the default index. Run your Ignite server with system property or environment varialy IGNITE_MAX_INDEX_PAYLOAD_SIZE=64. Finally, the operations you're doing don't look like something to be done with SQL. Consider using key-value API in Ignite C++ instead - https://apacheignite-cpp.readme.io/docs. Stan On Sat, Nov 2, 2019 at 8:15 PM Evgenii Zhuravlev <e.zhuravlev...@gmail.com<mailto:e.zhuravlev...@gmail.com>> wrote: Hi, Do you use only one ODBC client? Can you start one more ODBC client and check the performance? Thanks, Evgenii сб, 2 нояб. 2019 г. в 16:47, Siew Wai Yow <wai_...@hotmail.com<mailto:wai_...@hotmail.com>>: Hi, We are doing POC on ignite performance using ODBC driver but the performance is always capped at around 1700 TPS which is too slow. It is local ignite service. All tuning tips from Ignite page has been applied, no bottleneck from CPU and Memory. At the moment not turn on persistence yet, it will be worse if turn on. This POC is very crucial to our product roadmap. Any tips? Thank you. Test case, 1 x insert --> 49 x select -->49 x update --> 1 x delete repeat for 50000 times. const char* insert_sql = "insert into CDRTEST values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; const char* update_sql = "update CDRTEST set value01=?,value02=?,value03=?,value04=?,value05=?,value21=?,value22=?,value23=?,value24=?,value25=? where key01=?"; const char* delete_sql = "delete from CDRTEST where key01=?"; const char* select_sql = "select value01 from CDRTEST where key01=?"; retcode = SQLExecDirect(hstmt, reinterpret_cast<SQLCHAR*>(const_cast<char*>("CREATE TABLE IF NOT EXISTS CDRTEST ( " "key01 VARCHAR PRIMARY KEY, " "value01 LONG, " "value02 LONG, " "value03 LONG, " "value04 LONG, " "value05 LONG, " "value06 LONG, " "value07 LONG, " "value08 LONG, " "value09 LONG, " "value10 LONG, " "value11 LONG, " "value12 LONG, " "value13 LONG, " "value14 LONG, " "value15 LONG, " "value16 LONG, " "value17 LONG, " "value18 LONG, " "value19 LONG, " "value20 LONG, " "value21 VARCHAR, " "value22 VARCHAR, " "value23 VARCHAR, " "value24 VARCHAR, " "value25 VARCHAR, " "value26 VARCHAR, " "value27 VARCHAR, " "value28 VARCHAR, " "value29 VARCHAR, " "value30 VARCHAR, " "value31 VARCHAR, " "value32 VARCHAR, " "value33 VARCHAR, " "value34 VARCHAR, " "value35 VARCHAR, " "value36 VARCHAR, " "value37 VARCHAR, " "value38 VARCHAR, " "value39 VARCHAR) " "WITH \"template=partitioned,atomicity=TRANSACTIONAL_SNAPSHOT,WRITE_SYNCHRONIZATION_MODE=FULL_ASYNC\"")), SQL_NTS); CHECK_ERROR(retcode, "Fail to create table", hstmt, SQL_HANDLE_STMT); retcode = SQLExecDirect(hstmt, reinterpret_cast<SQLCHAR*>(const_cast<char*>("CREATE INDEX key01t_idx ON CDRTEST(key01) INLINE_SIZE 64")), SQL_NTS); CHECK_ERROR(retcode, "Fail to create index", hstmt, SQL_HANDLE_STMT); Below are configuration we used, <?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="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> <property name="clientConnectorConfiguration"> <bean class="org.apache.ignite.configuration.ClientConnectorConfiguration"> <!--property name="host" value="127.0.0.1"/--> <!--property name="port" value="10800"/--> <!--property name="portRange" value="5"/--> <property name="maxOpenCursorsPerConnection" value="512"/> <property name="socketSendBufferSize" value="65536"/> <property name="socketReceiveBufferSize" value="131072"/> <!--property name="threadPoolSize" value="4"/--> </bean> </property> <property name="dataStorageConfiguration"> <bean class="org.apache.ignite.configuration.DataStorageConfiguration"> <!-- Enabling Apache Ignite Persistent Store. --> <property name="defaultDataRegionConfiguration"> <bean class="org.apache.ignite.configuration.DataRegionConfiguration"> <property name="persistenceEnabled" value="false"/> </bean> </property> <property name="walPath" value="/ignite-wal"/> <property name="walArchivePath" value="/ignite-wal"/> </bean> </property> </bean> </beans> Regards, Yow
odbcsample.cc
Description: odbcsample.cc