[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
swy updated IGNITE-12374:
-
Attachment: odbcsample.cc
> Too low performance ~200TPS for single ODBC client
>
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
swy updated IGNITE-12374:
-
Attachment: values.yaml
> Too low performance ~200TPS for single ODBC client
>
swy created IGNITE-12374:
Summary: Too low performance ~200TPS for single ODBC client
Key: IGNITE-12374
URL: https://issues.apache.org/jira/browse/IGNITE-12374
Project: Ignite
Issue Type:
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
swy updated IGNITE-12374:
-
Description:
Hi, in our test ignite performance with ODBC connection is too bad to proceed
with product
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
swy updated IGNITE-12374:
-
Description:
Hi, in our test ignite performance with ODBC connection is too bad to proceed
with product
[
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
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
swy updated IGNITE-12374:
-
Attachment: odbcsample.allchar.rebind.cc
> 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
[
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
[
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.
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16986884#comment-16986884
]
swy edited comment on IGNITE-12374 at 12/3/19 1:13 PM:
---
Thanks [~zstan]. The
[
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
[
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
[
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
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
swy resolved IGNITE-12374.
--
Resolution: Information Provided
> Too low performance ~200TPS for single ODBC client
>
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
swy closed IGNITE-12374.
Ignite Flags: (was: Docs Required,Release Notes Required)
> 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
[
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
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
swy updated IGNITE-12374:
-
Description:
Hi, in our test ignite performance with ODBC connection is too bad to proceed
with product
[
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.
>
[
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
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
swy updated IGNITE-12374:
-
Attachment: profiling03.png
> 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
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
swy updated IGNITE-12374:
-
Attachment: threaddump-1573207804944.tdump
> Too low performance ~200TPS for single ODBC client
>
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
swy updated IGNITE-12374:
-
Attachment: profiling01.png
> Too low performance ~200TPS for single ODBC client
>
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
swy updated IGNITE-12374:
-
Attachment: profling02.png
> Too low performance ~200TPS for single ODBC client
>
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
swy updated IGNITE-12374:
-
Attachment: threaddump-1574845414243.tdump
> Too low performance ~200TPS for single ODBC client
>
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
swy updated IGNITE-12374:
-
Attachment: snapshot-1574845275597.nps
> 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
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
swy updated IGNITE-12374:
-
Attachment: ignite-9bb53f34.0.log
> 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
[
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:
[
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
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982051#comment-16982051
]
swy edited comment on IGNITE-12374 at 11/26/19 2:19 AM:
[~isapego] any clue to
[
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
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
swy updated IGNITE-12374:
-
Attachment: (was: ignite-logs-config-source-20191128.zip)
> Too low performance ~200TPS for single ODBC
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
swy updated IGNITE-12374:
-
Attachment: ignite-logs-config-source-20191128.zip
> 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 edited comment on IGNITE-12374 at 11/28/19 3:28 AM:
[~zstan] please find
[
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:
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984121#comment-16984121
]
swy edited comment on IGNITE-12374 at 11/28/19 3:31 AM:
[~zstan] please find
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984077#comment-16984077
]
swy edited comment on IGNITE-12374 at 11/28/19 1:58 AM:
I found the timezone
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
swy updated IGNITE-12374:
-
Attachment: ignite-logs-config-source-20191128.zip
> 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 edited comment on IGNITE-12374 at 11/29/19 9:19 AM:
hi [~zstan], please
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
swy updated IGNITE-12374:
-
Attachment: ignite-logs-config-source-20191129.zip
> 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
[
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
[
https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
swy updated IGNITE-12374:
-
Attachment: screenshot-1.png
> 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
48 matches
Mail list logo