Hello! I assume we're still talking about your reproducer https://github.com/RedBlackTreei/streamer.git With your code and reduced data set of 25000000
Total time:628120ms when using cacheCfg.setSqlIndexMaxInlineSize(64); devIdIdx.setInlineSize(96); as opposed to Total time:820821ms with your settings. devIdIdx needs to be so large due to https://issues.apache.org/jira/browse/IGNITE-11125 - it will include _key :( This may look slow, so generic optimizations might be needed: - Have larger data region and/or more nodes. - If possible load with WAL disabled (you can do that in runtime on per cache basis). - If not, have less frequent checkpoints and larger checkpoint page buffer size. Regards, -- Ilya Kasnacheev пт, 1 мар. 2019 г. в 18:02, Justin Ji <[email protected]>: > I have tried to increase QueryIndex.setInlineSize and > CacheConfiguration.setSqlIndexMaxInlineSize to 128 256 and 512, but the > performace became worse. > > Do I miss some configuration? > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
