I have just began experimenting with Apache Ignite as an IMDG. I have imported a single table (~42 million, 15 columns - mostly integer/decimal datatypes) in a new cluster created in GridGain Web console and created a new JAVA project. I initially defined the cache as partitioned and did not define an affinity key... assuming it defaulted to Id PK column of the table. The loadCache for my full data ran in ~16 minutes on a single node on a moderate sized 2CPU 32Gb Win machine. I want to use another integer column as the affinity key for colocation purposes. However, the loadCache process for this new cache structure with an object as the key (Id + affinity column) is dramatically slower than before. I am able to load at the rate of ~1 million records per 10 minutes or so. I am using Ignite 2.9.1 and GridGain libs 8.7.9. Is this expected or is there some configuration that I might be missing? Any suggestions?
-- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
