Re: Ignite Select Query Performance
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: http://apache-ignite-users.70518.x6.nabble.com/
Ignite Select Query Performance
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 MemSQL database on same hardware environment and the above query was executed in 6 seconds. Why is the execution time so long in Ignite database? Is there something missing in Ignite while executing select queries with huge offset? Please let me know if you require any further information regarding our test case. Regards, Shravya Nethula. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/