I am completely new to Apache Ignite and trying out some examples for evaluating IMDG capabilities of Ignite. I am using GridGain web console to create a simple project where I have imported a single table from my MS-SQL external persistent database. This is a large table with ~9 million records with over 100 columns. After downloading the project, compiling in VS Code, and deploying the packaged JAR file in ignite installation folder, I start the cluster (single node). So far so good, I can see the cluster and node in my GridGain browser web console. However, every time I try to load the cache (using Web Console Load on my cache), it only loads ~44K records which I am able to query (e.g. using DBeaver). I tried setting the dataRegion mem size to 12G. The machine has 32G RAM and over 70% is free. The cache does have Read-Through enabled and I understand that key-value access via API can read all data. However I am trying to run SQL on the cache to aggregate the data for my evaluation. Why does the cacheLoad process not load all data from my external MSSQL DB? Any thoughts? Thanks in advance.
-- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
