Hi, "AsParallel" is the problem, it causes the entire data set to be loaded locally before filtering.
Remove it so that the LINQ expression can be translated into Ignite SQL and executed more efficiently. https://ignite.apache.org/docs/latest/net-specific/net-linq On Tue, Nov 5, 2024 at 8:58 AM Charlin S <charli...@hotelhub.com> wrote: > Hi All, > > I am trying Ignit.Net LINQ for the first time and seeing very slowness > with my linq query taking 13-15 seconds. Test model having 550,000 records > my query as below > TestModel having index for CountryCode field. > ICache<string, TestModel> cache = ignite.GetCache<string, > TestModel>(CacheName); > IQueryable<ICacheEntry<string, TestModel>> igniteQuerable = > cache.AsCacheQueryable(); > igniteQuerable.AsParallel() > .Where(x=>string.Equals(x.Value.CountryCode, criteria. > CountryCode, StringComparison.CurrentCultureIgnoreCase)) > .Select(x => x.Key).ToList(); > > > Regards, > Charlin > >
