ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anil <anilk...@gmail.com>
Subject Re: Ignite Jdbc connection
Date Sat, 05 Nov 2016 19:06:28 GMT
Hi Manu and All,

Ignite jdbc connection is very slow for very first time even with data
source.

Consecutive queries are very fast. queries with 1 mins time duration
becoming slow.

PoolProperties p = new PoolProperties();
         p.setUrl("jdbc:ignite:cfg://cache=TEST_CACHE@file:" +
System.getProperties().getProperty("ignite.config.file"));
         p.setDriverClassName("org.apache.ignite.IgniteJdbcDriver");
         p.setMaxActive(20);
         p.setInitialSize(5);
         p.setMaxWait(5000);
         p.setMinIdle(5);
         p.setMaxIdle(10);
         p.setTestOnBorrow(true);
         p.setTestWhileIdle(true);
         p.setTestOnReturn(true);
         p.setTimeBetweenEvictionRunsMillis(60000);
         p.setMinEvictableIdleTimeMillis(120000);
         p.setMaxAge(1500000);
         p.setRemoveAbandoned(true);
         p.setRemoveAbandonedTimeout(300);
         p.setLogAbandoned(true);
         p.setFairQueue(true);
         p.setValidationQuery("select count(*) from \"TEST_CACHE\".Person
limit 1");
         p.setValidationInterval(3000);
         ds = new DataSource();
         ds.setPoolProperties(p);
 anyone facing the similar problem ?

Thanks.

Mime
View raw message