Ignite Select Query Performance

classic Classic list List threaded Threaded
2 messages Options
Shravya Nethula Shravya Nethula
Reply | Threaded
Open this post in threaded view
|

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 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
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/
aealexsandrov aealexsandrov
Reply | Threaded
Open this post in threaded view
|

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/