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 <saif.m...@gmail.com> wrote: > 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? > > <?xml version="1.0" encoding="UTF-8"?> > <beans xmlns="http://www.springframework.org/schema/beans" > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > xmlns:util="http://www.springframework.org/schema/util" > xsi:schemaLocation="http://www.springframework.org/schema/beans > http://www.springframework. > org/schema/beans/spring-beans.xsd > http://www.springframework.org/schema/util > http://www.springframework. > org/schema/util/spring-util.xsd"> > > <bean id="ignite.cfg" class="org.apache.ignite.configuration. > IgniteConfiguration"> > <bean id="myDataSource" class="org.springframework.jdbc.datasource. > DriverManagerDataSource"> > <property name="driverClassName" > value="com.microsoft.sqlserver.jdbc.SQLServerDriver" > /> > <property name="url" > value="jdbc:sqlserver://localhost:1433;databaseName=TransactionsDB" > /> > <property name="username" value="user1" /> > <property name="password" value="password123" /> > </bean> > <!-- Enabling ODBC. --> > <property name="odbcConfiguration"> > <bean class="org.apache.ignite.configuration.OdbcConfiguration"/> > </property> > </bean> > <property name="cacheConfiguration"> > <list> > <bean class="org.apache.ignite.configuration.CacheConfiguration"> > <property name="dataSourceBean" value="myDataSource" /> > <property name="databaseSchema" value="dbo" /> > <property name="name" value="transactionsdetail"/> > <property name="databaseTable" > value="transactionsdetail" /> > </bean> > </list> > </property> > </beans> > > Getting following error > > Failed to instantiate configuration from Spring XML > > Thanks, > Saif > > On Wed, Mar 15, 2017 at 8:29 PM, Pavel Tupitsyn <ptupit...@apache.org> > wrote: > >> Have you tried commenting out cache store as I descrived above? >> >> On Wed, Mar 15, 2017 at 6:10 PM, Saifullah Zahid <saif.m...@gmail.com> >> 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 void LoadCache(Action<object, object> act, params object[] args) >>> { >>> using (DbConnection _connection = Create()) >>> { >>> using (DbCommand command = _connection.CreateCommand()) >>> { >>> MakeLoadCacheCommand(command, args); >>> using (var reader = command.ExecuteReader()) >>> { >>> while (reader.Read()) >>> { >>> var item = new T(); >>> Map(reader, item); //populate object >>> * act(GetKeyValue(item), item); //insert into cache* >>> } >>> } >>> } >>> } >>> } >>> >>> Looks like issue is when inserting data into cache. >>> >>> Thanks, >>> Saif >>> >>> >>> On Wed, Mar 15, 2017 at 7:02 PM, Pavel Tupitsyn <ptupit...@apache.org> >>> wrote: >>> >>>> 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 <saif.m...@gmail.com> >>>> wrote: >>>> >>>>> 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 >>>>> >>>> >>>> >>> >> >