Re: Ignite Select Query Performance

2018-10-17 Thread aealexsandrov
Hi, We can try to check can your configuration be improved but first of all could you please provide some details: 1)How many data nodes you used. 2)Data node configuration 3)Cache configuration or DML Create Table command for your cache (table) BR, Andrei -- Sent from:

Ignite Select Query Performance

2018-10-16 Thread Shravya Nethula
Hi, We have inserted a table in Ignite with 10 million rows. The execution time for the following query is around 10 seconds: *select * from tableName offset 500 rows fetch next 100 rows only* The Ignite database was installed on servers with 150 GB RAM. The same table was inserted in