RE: Performance of Ignite integrating with PostgreSQL

2018-03-27 Thread itriA40453
Hi Vinokurov, I tried to run your code for 30 minutes monitored by “atop”. And the average write speed is about 2151.55 KB per second. Though the performance is better. But there is still a gap with your testing result. Is there anything I can improve? Thanks. There is my hardware specifications.

RE: Performance of Ignite integrating with PostgreSQL

2018-03-27 Thread itriA40453
Hi Vinokurov, I tried to run your code for 30 minutes monitored by “atop”. And the average write speed is about 2151.55 KB per second. Though the performance is better. But there is still a gap with your testing result. Is there anything I can improve? Thanks. There is my hardware specifications.

RE: Performance of Ignite integrating with PostgreSQL

2018-03-22 Thread itriA40453
Hi Vinokurov, I changed my code >> IgniteCache igniteCache = ignite.getOrCreateCache("testCache >> "); To IgniteCache igniteCache = ignite.cache("testCache"); And update to 2.4.0 version. But the writing speed is still about 100 KB per second. Below is jdbc connection initialization: @Autowire

RE: Performance of Ignite integrating with PostgreSQL

2018-03-20 Thread itriA40453
Hi Vinokurov, Thanks for your reply. I try to write batches by 100 entries. And I got a worse result. The writing speed is down to 12.09 KB per second. Below is my code which I try to use putAll and writeAll to rewrite. Did I make some mistakes? Main function: Ignite ignite = Ignition.s

Performance of Ignite integrating with PostgreSQL

2018-03-14 Thread itriA40453
Hi, I try to use Ignite to integrate with PostgreSQL. And I use “atop” to monitor the data write to PostgreSQL. Then observed that the writing speed is 1 MB per second. This performance is not really good. Below is my configuration and code. Please help me to improve it. Thanks. There is my cache

RE: Ignite cache TTL and SQL query

2018-02-28 Thread itriA40453
Hi Denis, Thanks for your reply. I am asking about SQL query in Ignite. And I set PostgreSQL for Ignite to store data on disk. Now I know this question is still unresolved. Thanks. From: Denis Mekhanikov [mailto:dmekhani...@gmail.com] Sent: Tuesday, February 27, 2018 10:22 PM To: user@ignite.a

Ignite cache TTL and SQL query

2018-02-26 Thread itriA40453
Hi, I have read the reply below. http://apache-ignite-users.70518.x6.nabble.com/Eager-TTL-and-query-td11662.html It mentioned that TTL will only update by IgniteCache API (put/get/invoke and etc). And SQL query won’t update TTL. I use PostgreSQL as persistence store. Is there any method to upda

Use SQL to query IgniteRDD with scala at Zeppelin

2018-01-11 Thread itriA40453
Hi, Below is my code and result where I am trying to query IgniteRDD through SQL statement with scala at Zeppelin. First I use restful API to put a pair of data(key=10, val=45) into Ignite cache. %python import requests requests.put("http://127.0.0.1:8080/ignite?cmd=put&key=10&val=45&cacheName=ze