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 5000000 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
Please let me know if you require any further information regarding our test