'Hazelcast SQL Performance Issue

I am trying to query Hazelcast cache Using Hazelcast-SQL which contains a map having around 140 columns.

When we try to query with all columns in select query then it took around 8 sec. But when we reduce number of columns to around 60 then its taking less than 1 sec

Our requirement is to query all columns.

How can we optimize it ?

Sample Query - Select A,B,C from where Id =

Steps I have taken -

1- Created index on Map properly



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source