Re: Performance of Ignite integrating with PostgreSQL

Also it makes sense to use new 2.4 version. 2018-03-22 8:37 GMT+03:00 Vinokurov Pavel <vinokurov.pa...@gmail.com>: > >> IgniteCache<String, String> igniteCache = ignite.getOrCreateCache(" > testCache "); > please, change to ignite.cache("testCache&qu

Re: Performance of Ignite integrating with PostgreSQL

>> IgniteCache<String, String> igniteCache = ignite.getOrCreateCache("testCache "); please, change to ignite.cache("testCache") to be sure the we use configuration from the file. 2018-03-22 8:19 GMT+03:00 Vinokurov Pavel <vinokurov.pa...@gmail.com>: > Y

Re: Performance of Ignite integrating with PostgreSQL

You already showed the cache configuration, but could you show jdbc connection initialization 2018-03-22 7:59 GMT+03:00 Vinokurov Pavel <vinokurov.pa...@gmail.com>: > Hi, > > Could you please show the "PATH/example-cache.xml" file. > > 2018-03-21 9:40 GMT+03:00 &l

Re: Performance of Ignite integrating with PostgreSQL

),(:val65),(:val66),(:val67),(:val68),(:val69),(:val70)," > >+ "(:val71),(:val72),(:val73),(: > val74),(:val75),(:val76),(:val77),(:val78),(:val79),(:val80)," > >+ "(:val81),(:val82),(:val83),(: > val84),(:val85),(:val86),(:val87),(:v

Re: ContinuousQuery - SqlFieldsQuery as InitialQuery

Hello! At the compilation time it is impossible to know result type of the SqlFieldsQuery. So you can try following: ((ContinuousQuery)q).setInitialQuery(new SqlFieldsQuery("select _val from table")); Thanks, Pavel 2018-03-20 20:43 GMT+03:00 au.fp2018 : > Hello All, > >

Re: Performance of Ignite integrating with PostgreSQL

Hi, You could try to use igniteCache.putAll for write batches by 1000 entries. Use following script in PostgresDBStore#writeAll method to put data into the database: String sqlString = "INSERT INTO test(val) VALUES (:val1)(:val2)(:val3);"; 2018-03-14 11:58 GMT+03:00 :

Re: Timeout while running checkpoint

2018-02-12 09:13:37 [db-checkpoint-thread-#33%nvIDNSGN7CR%] INFO > GridCacheDatabaseSharedManager:463 - Skipping checkpoint (no pages were > modified) [checkpointLockWait=0ms, checkpointLockHoldTime=2ms, > reason='timeout'] > > > > > > *From:* Vinokurov Pavel [mailto:vino

Re: Timeout while running checkpoint

How often the "Skipping checkpoint" message occurred in logs? 2018-02-12 10:47 GMT+03:00 Josephine Barboza <josephine.barb...@nviz.com>: > No I haven’t overridden checkpointFreq value. > > > > *From:* Vinokurov Pavel [mailto:vinokurov.pa...@gmail.com] > *Sent:*

Re: Add ignite jars using maven

I think the right way is to add dependencies into the pom file. 2018-02-12 10:37 GMT+03:00 Rajarshi Pain : > Hi, > > > Previously i was manually adding all the jars to my build path, now i am > using maven to do this. Is there any way to add all ignite jars with it's >

Re: Timeout while running checkpoint

Hi, The timeout could be caused by value PersistentStoreConfiguration#checkpointFreq parameter. Have you overrided *checkpointFreq* config parameter? 2018-02-12 10:05 GMT+03:00 Josephine Barboza : > Hi, > > I’m constantly seeing a lot of information logs after

Re: Ignite with Spring Cache on K8S, eviction problem

Spring creates a composite key that might be not suitable for the distributed Ignite cache. You could use the custom composite key using concatenation #user+ " - "+#id. 2018-02-09 17:50 GMT+03:00 lukaszbyjos : > Hi. I have k8s cluster with one ignite server and few

Re: Loading cache from Oracle Table

Hi Prasad, Within your implementation of CacheStore.loadCacheYou you could use multiple threads to retrieve rows by batches. Note that each thread should use different jdbc connection. 2018-02-09 13:57 GMT+03:00 Prasad Bhalerao : > Hi, > > I have multiple oracle

Re: continuous query - changes from local server only

Som, You could create the continuous query on each client node with the filter described above. 2018-02-08 19:55 GMT+03:00 Som Som <2av10...@gmail.com>: > i've got both client and server nodes on each of 3 physical servers, that > is my cluster. there is a partitioned cache, each server node

Re: code sample for cluster configuration

Hi Rajesh, There is a good sample with enabled persistance - https://github.com/apache/ignite/blob/master/examples/src/main/java/org/apache/ignite/examples/persistentstore/PersistentStoreExample.java Also documentation about Ignite persistance presented in