Ok, in this case,I did not tell about loading cache.
It is about persistent data.
I want to insert 500000 records into DB.
my setting is:
cacheCfg.setWriteBehindEnabled(true);
cacheCfg.setWriteBehindFlushSize(10240);
cacheCfg.setWriteBehindFlushFrequency(10000);
cacheCfg.setWriteBehindBatchSize(10000);
cacheCfg.setWriteBehindFlushThreadCount(3);
My question is:
1.WriteBehindEnabled parameter is set to true,but it seems not work.
String sql = "insert into "mycache1".tableA(_key,fid,fname)
select(fid,fid,orgid) from "mycache2".tableB";
cache.query(new SqlFieldQuery(sql));
this is update data to DB.
but it wait until all data has finished persistent to DB.
I just hope the flow can run continue when the cache is updated ,but not need
to wait persistent .
2. setWriteBehindBatchSize is set to 10000 and setWriteBehindFlushFrequency is
set to 5 seconds,but in the log ,I see that is not 10000 each time,and There
is no interval of 10 seconds
Thanks.
Lucky
At 2017-07-21 03:18:06, "vkulichenko" <[email protected]> wrote:
>Hi Lucky,
>
>Write behind affects the way how underlying store is updated when you update
>the cache. Load cache process is different and is not related to this. More
>information here: https://apacheignite.readme.io/docs/persistent-store
>
>-Val
>
>
>
>--
>View this message in context:
>http://apache-ignite-users.70518.x6.nabble.com/about-write-behind-problems-tp15160p15205.html
>Sent from the Apache Ignite Users mailing list archive at Nabble.com.
