Mailing-List: contact user-help@ignite.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ignite.apache.org
MIME-Version: 1.0
From: Saifullah Zahid <saif.muet@gmail.com>
Date: Wed, 15 Mar 2017 18:02:36 +0500
Message-ID: <CANnzydd6QwfiVu3bw2UGbUoNrr78cMomgycZYRLgvRqj_wtL5A@mail.gmail.com>
Subject: Ignite.NET very slow Cache Loading
To: user@ignite.apache.org
Content-Type: multipart/alternative; boundary=001a114c90520656e0054ac48f0d
archived-at: Wed, 15 Mar 2017 13:32:18 -0000

--001a114c90520656e0054ac48f0d
Content-Type: text/plain; charset=UTF-8

Hi,

I am facing an issue on cache loading, In the start cache loads quickly but
after some time it becomes very slow almost 1 row per second.
There are about 4 million rows in a table.
OS = Windows Server 2012
RAM = 64 GB
Node Heap config is 16 GB.
Following is Cache configuration

TransactionsDetailStore = m_cache.GetOrCreateCache<int,
TransactionsDetail>(new CacheConfiguration("transactionssdetail",
typeof(TransactionsDetail))
{
CacheStoreFactory = new TransactionsDetailStoreFactory("ApplicationDB",
true),
ReadThrough = true,
WriteThrough = true,
WriteBehindEnabled = true,
KeepBinaryInStore = false,
WriteBehindFlushThreadCount = 4,
WriteBehindFlushFrequency = new TimeSpan(0, 0, 2),
MemoryMode = CacheMemoryMode.OffheapTiered,
OffHeapMaxMemory = 0,
EvictionPolicy = new LruEvictionPolicy { MaxSize = 1000000 },
WriteSynchronizationMode = CacheWriteSynchronizationMode.FullSync
});

Am I missing some configuration?
Kindly see if anyone have idea?

Thanks,
Saif

--001a114c90520656e0054ac48f0d
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi,=C2=A0</div><div><br></div><div>I am facing an iss=
ue on cache loading, In the start cache loads quickly but after some time i=
t becomes very slow almost 1 row per second.=C2=A0</div><div>There are abou=
t 4 million rows in a table.</div><div>OS =3D Windows Server 2012</div><div=
>RAM =3D 64 GB</div><div>Node Heap config is 16 GB.</div><div>Following is =
Cache configuration</div><div><br></div><div>TransactionsDetailStore =3D m_=
cache.GetOrCreateCache&lt;int, TransactionsDetail&gt;(new CacheConfiguratio=
n(&quot;transactionssdetail&quot;, typeof(TransactionsDetail))</div><div>{<=
/div><div><span class=3D"gmail-Apple-tab-span" style=3D"white-space:pre">	<=
/span>CacheStoreFactory =3D new TransactionsDetailStoreFactory(&quot;Applic=
ationDB&quot;, true),</div><div><span class=3D"gmail-Apple-tab-span" style=
=3D"white-space:pre">	</span>ReadThrough =3D true,</div><div><span class=3D=
"gmail-Apple-tab-span" style=3D"white-space:pre">	</span>WriteThrough =3D t=
rue,</div><div><span class=3D"gmail-Apple-tab-span" style=3D"white-space:pr=
e">	</span>WriteBehindEnabled =3D true,</div><div><span class=3D"gmail-Appl=
e-tab-span" style=3D"white-space:pre">	</span>KeepBinaryInStore =3D false, =
=C2=A0</div><div><span class=3D"gmail-Apple-tab-span" style=3D"white-space:=
pre">	</span>WriteBehindFlushThreadCount =3D 4,</div><div><span class=3D"gm=
ail-Apple-tab-span" style=3D"white-space:pre">	</span>WriteBehindFlushFrequ=
ency =3D new TimeSpan(0, 0, 2),</div><div><span class=3D"gmail-Apple-tab-sp=
an" style=3D"white-space:pre">	</span>MemoryMode =3D CacheMemoryMode.Offhea=
pTiered,</div><div><span class=3D"gmail-Apple-tab-span" style=3D"white-spac=
e:pre">	</span>OffHeapMaxMemory =3D 0,</div><div><span class=3D"gmail-Apple=
-tab-span" style=3D"white-space:pre">	</span>EvictionPolicy =3D new LruEvic=
tionPolicy { MaxSize =3D 1000000 },</div><div><span class=3D"gmail-Apple-ta=
b-span" style=3D"white-space:pre">	</span>WriteSynchronizationMode =3D Cach=
eWriteSynchronizationMode.FullSync</div><div>});</div><div><br></div><div>A=
m I missing some configuration?</div><div>Kindly see if anyone have idea?</=
div><div><br></div><div>Thanks,</div><div>Saif</div></div>

--001a114c90520656e0054ac48f0d--