Hi Sumit, What is version of Ignite do you use? Do you observe any CPU load? Would you please share query plan? You can get it via H2 console [1]. Do you create table via "CREATE TABLE" SQL command.
It is possible, simple queries by PK are broken and full scan performed instead of using index in some cases in 2.1 version. This already fixed and will be available from 2.3 that is coming soon. [1] https://apacheignite.readme.io/v2.2/docs/sql-performance-and-debugging#using-h2-debug-console On Wed, Oct 18, 2017 at 12:03 PM, Sumit Sethia <[email protected]> wrote: > Hi Alexander, there is no suspicious log as far as I can see. > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ > -- Best regards, Andrey V. Mashenkov
