[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16991441#comment-16991441 ] Stanilovsky Evgeny commented on IGNITE-12374: - [~yow] plz close this ticket and use 2.7.6

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16990771#comment-16990771 ] swy commented on IGNITE-12374: -- Alright [~zstan], we have no choice but to take this, thank you. > Too

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16989701#comment-16989701 ] Stanilovsky Evgeny commented on IGNITE-12374: - [~yow] look, you can got some speed boost if

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16989404#comment-16989404 ] Stanilovsky Evgeny commented on IGNITE-12374: - [~yow] give me one more day, i will share my

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16989368#comment-16989368 ] swy commented on IGNITE-12374: -- [~zstan] any good news to share? Can I say this is the most out of apache

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16987679#comment-16987679 ] swy commented on IGNITE-12374: -- The intention is to have single instance run as closer as 10k to meet our

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16987594#comment-16987594 ] Stanilovsky Evgeny commented on IGNITE-12374: - 8 * 2128 = already yours 10k ) i`l try to

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16986940#comment-16986940 ] swy commented on IGNITE-12374: -- unfortunately our product run in single thread and not so easy to refactor

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16986896#comment-16986896 ] Stanilovsky Evgeny commented on IGNITE-12374: - after warmup, results are more better:

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16986889#comment-16986889 ] Stanilovsky Evgeny commented on IGNITE-12374: - [~isapego] may be you can spot additional

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16986884#comment-16986884 ] swy commented on IGNITE-12374: -- Thanks [~zstan]. The performance is better now with 1220 TPS.

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16986677#comment-16986677 ] Stanilovsky Evgeny commented on IGNITE-12374: - simple tuning give me perf boost:

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16986673#comment-16986673 ] Stanilovsky Evgeny commented on IGNITE-12374: - initial run with your "my-config":

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16986591#comment-16986591 ] swy commented on IGNITE-12374: -- 'long' should be enough. By using "PRIMARY_SYNC" performance is slightly

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16986085#comment-16986085 ] Stanilovsky Evgeny commented on IGNITE-12374: - ok, check it ! can you avoid of bigint usage

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16986056#comment-16986056 ] swy commented on IGNITE-12374: -- [~zstan] in my lab, 1 node with persistence=true:

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16985937#comment-16985937 ] Stanilovsky Evgeny commented on IGNITE-12374: - i attach mine odbcsample may be would

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16985883#comment-16985883 ] Stanilovsky Evgeny commented on IGNITE-12374: - additionally: forgot to apply your config,

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16985869#comment-16985869 ] Stanilovsky Evgeny commented on IGNITE-12374: - initial run show this result :

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16985063#comment-16985063 ] Stanilovsky Evgeny commented on IGNITE-12374: - catch it ! but not i can`t find : Possible

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16985018#comment-16985018 ] swy commented on IGNITE-12374: -- The safepoint.log is in ignite-logs-config-source-201911*29*.zip, please

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16985004#comment-16985004 ] Stanilovsky Evgeny commented on IGNITE-12374: - thanks will try it, can`t find

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984837#comment-16984837 ] swy commented on IGNITE-12374: -- hi [~zstan], please check attachment

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984768#comment-16984768 ] Stanilovsky Evgeny commented on IGNITE-12374: - [~yow] 3. I think this is your main problem,

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984436#comment-16984436 ] swy commented on IGNITE-12374: -- [~zstan] 1. ok 2. yes persistency is our requirement not to loss any data

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984169#comment-16984169 ] Stanilovsky Evgeny commented on IGNITE-12374: - ok, [~yow] thanks for info, lets go :) 1. I

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984121#comment-16984121 ] swy commented on IGNITE-12374: -- [~zstan] please find ignite-logs-config-source-20191128.zip attached. It

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984077#comment-16984077 ] swy commented on IGNITE-12374: -- the time is matched, or you mean others? In log:

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16983720#comment-16983720 ] Stanilovsky Evgeny commented on IGNITE-12374: - ok, but dump time not intersects with logs

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16983502#comment-16983502 ] swy commented on IGNITE-12374: -- Of course! please find ignite-9bb53f34.0.log in attachment. > Too low

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16983356#comment-16983356 ] Stanilovsky Evgeny commented on IGNITE-12374: - ok , but i request : "attach logs" ,

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16983303#comment-16983303 ] swy commented on IGNITE-12374: -- [~zstan] please find new thread-dump and snapshot from JVisual, with

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16983226#comment-16983226 ] Stanilovsky Evgeny commented on IGNITE-12374: - [~yow] i check attached thread dump? only

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16983154#comment-16983154 ] swy commented on IGNITE-12374: -- [~isapego] I have post in user list as well but not helpful. I did

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982606#comment-16982606 ] Igor Sapego commented on IGNITE-12374: -- [~yow] I'm a little bit busy now. Try writing to user

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982051#comment-16982051 ] swy commented on IGNITE-12374: -- [~isapego] any clue to share? Or can I conclude this is the limit of

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16979001#comment-16979001 ] swy commented on IGNITE-12374: -- [~isapego] to make it simpler we have changed all fields to varchar to get

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16978443#comment-16978443 ] swy commented on IGNITE-12374: -- [~isapego] good catch, thanks. let me try again tomorrow 1. to rebind

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16978395#comment-16978395 ] Igor Sapego commented on IGNITE-12374: -- [~yow] It looks like you are fetching LONG value as a

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16978386#comment-16978386 ] Igor Sapego commented on IGNITE-12374: -- I think that binding will not take a lot of resources, so

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16978366#comment-16978366 ] swy commented on IGNITE-12374: -- fyi if we removed the SELECT query the application can reach 2500 TPS. >

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16978358#comment-16978358 ] swy commented on IGNITE-12374: -- Thank you [~isapego], also I have doubt if we should rebind everytime a

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16978298#comment-16978298 ] Igor Sapego commented on IGNITE-12374: -- [~yow] I checked out the sample code and I have a feeling

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16978296#comment-16978296 ] Igor Sapego commented on IGNITE-12374: -- [~yow] I just trying to locate where exactly the issue is,

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16978122#comment-16978122 ] swy commented on IGNITE-12374: -- Hi [~isapego] with native SQL interface the most can get is around 1000

[jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client

[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16974998#comment-16974998 ] Igor Sapego commented on IGNITE-12374: -- Hi, [~yow], have you tested the same scenario without ODBC