Details
-
Task
-
Status: Closed
-
Major
-
Resolution: Won't Fix
-
2.5
-
None
Description
When index page match condition, we eagerly read all matched data rows. This leads to a number of random disk reads.as Ignite use heap-organized storage. We can pre-sort all matched row links in accordance to their physical location, and then read them in batch. This will give us two important advantages:
1) Data reads will be more sequential, this is especially important for HDDs
2) This could decrease number of page reads in case of dense data placement, because there will be less evictions.
In future we should expand this optimization to several index pages in the same way it is done in major databases.