Can you please show slow query console log output if it's using index scan or full cache scan. I ran into one scenario where index wasn't used and it ended up scaning whole cache. You can try this locally by using control centre and run explain query
On Mon, 18 Apr 2022, 13:08 Charlin S, <charli...@hotelhub.com> wrote: > Hi Ignite team, > We are using Ignite 2.10.0 with 4.6.2 and .Net 5 WebAPI and we have a > 16-nodes(including 2 server nodes) Ignite cluster. > We are facing slowness issues with some particular cache model query and > other models query are fine. > > query type: SqlFieldsQuery > Index: index created for where clause columns. > > Regards, > Charlin > >
