Configuration of Ignite server backups = 1 persistenceEnabled = true atomicityMode = true
I have two nodes on one server and only one ignite server instance is running. I am using C# thin client to fetch data from collection. I am storing custom user defined object collection in my cache. 1. custom object has around 30 fields 2. collection contains around 7000 custom objects. 3. I am storing object by converting it to JSON Now when i fetch whole collection from cache using "ScanQuery" it is taking more time then traditional database (SQL/Oracle/Sybase) I create cache for each custom object collection like below ICacheClient<int, string> cacheClient = _igniteStore.IgniteThinClient.GetOrCreateCache<int, string>(typeof(T).FullName); and when i want to fetch all data from collection i do it like below var cacheEntries = cacheClient.Query(new Apache.Ignite.Core.Cache.Query.*ScanQuery<int, string>(null)).GetAll()*; I have tried multiple times but for my custom object which has 30 fields and collection has around 7k of this custom objects *It takes around 20000 milliseconds out of which 18500 milliseconds taken by "ScanQuery" statement above and 1500 milliseconds by newton json converter. If i fetch same from my traditional RDBMS (SQL) then it takes only 5500 milliseconds.* Can some one please let me know what i am doing wrong? Anything to do with configuration of ignite server or any other way to fetch all data from cache. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
