Re: Ignite.NET very slow Cache Loading

Hi Pavel, Thanks for your reply. There are about 40 fileds TransactionsDetail and size is about 400 bytes. In Taskbar I can see the process is taking about 23GB I used 20GB heap-size. Also I have noticed that c: drive have only 3GB empty space. Thanks, Saif On Thu, Mar 16, 2017 at 11:16 AM,

Re: Ignite.NET very slow Cache Loading

I tried that but it is throwing exception class org.apache.ignite.IgniteCheckedException: Cannot enable write-behind (writer or store is not provided) for cache: If I comment following settings ReadThrough = true, WriteThrough = true, WriteBehindEnabled = true, cache gets created but without

Re: Ignite.NET very slow Cache Loading

Why use Spring? I propose to do just one thing - comment out the CacheStoreFactory line. On Wed, Mar 15, 2017 at 7:30 PM, Saifullah Zahid wrote: > Hi, > > If I disable CacheStoreFactor then I have to provide the > CacheConfiguration in spring xml > But I don't know how to

Re: Ignite.NET very slow Cache Loading

Hi, If I disable CacheStoreFactor then I have to provide the CacheConfiguration in spring xml But I don't know how to provide Database and table mapping in spring xml, I tried following configuration but it is failing. I am not sure if it is right way to do?

Re: Ignite.NET very slow Cache Loading

Have you tried commenting out cache store as I descrived above? On Wed, Mar 15, 2017 at 6:10 PM, Saifullah Zahid wrote: > Hi, > > following is my load cache method > if I comments out following line of code, it does not slows down > act(GetKeyValue(item), item); > > public

Re: Ignite.NET very slow Cache Loading

Hi, following is my load cache method if I comments out following line of code, it does not slows down act(GetKeyValue(item), item); public void LoadCache(Action act, params object[] args) { using (DbConnection _connection = Create()) { using (DbCommand command =

Re: Ignite.NET very slow Cache Loading

Hi, You have cache store configured, which probably causes the slowdown. Please try to disable cache store (remove CacheStoreFactory from config) and see if it makes any difference. On Wed, Mar 15, 2017 at 4:02 PM, Saifullah Zahid wrote: > Hi, > > I am facing an issue on

Ignite.NET very slow Cache Loading

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