Re: Ignite query is taking long time even no data in that cache model

[Charlin S]

Hi,
My query details are
fieldsQuery="SELECT
TestField1,TestField2,TestField3,TestField4,TestField5
 FROM
TestModel
 WHERE
TestField2 = 'A02'
 AND
TestField2 = 'EN'"

//cache model
 public class TestModel : IBinarizable
    {

        [QuerySqlField(IsIndexed = true)]
        public string TestField1 { get; set; }
        [QuerySqlField(IsIndexed = true)]
        public string TestField2 { get; set; }
        [QuerySqlField(IsIndexed = true)]
        public string TestField3 { get; set; }
        [QuerySqlField]
        public string TestField4 { get; set; }
        [QuerySqlField]
        public decimal? TestField5 { get; set; }

        public void ReadBinary(IBinaryReader reader){//implementation}
        public void WriteBinary(IBinaryWriter writer){//implementation}
    }
implementation

SqlFieldsQuery fieldsQuery = new SqlFieldsQuery(query) { Timeout =
TimeSpan.FromMilliseconds(10000) };
                List<T> list = new List<T>();
// public ICache<string, T> IgniteCache { get; set; }
                IFieldsQueryCursor queryCursor =
IgniteCache.Query(fieldsQuery);

//our implementation
 queryCursor.Dispose();

Thanks,
Charlin



On Mon, 18 Apr 2022 at 13:35, Surinder Mehra <redni...@gmail.com> wrote:

> 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
>>
>>