20 seconds for a collection of 7k objects is way too slow. Can you please attach full reproducer so I can run it and dig deeper?
On Mon, Jan 13, 2020 at 2:47 PM Tunas <[email protected]> wrote: > 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/ >
