[ASTERIXDB-3433] Number of cloud read requests could be excessive

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 0.9.10
• Component/s: STO - Storage
• Labels: triaged
• Epic Link: Columnar Format
• Assignee: Ritik Raj
• Reporter: Ritik Raj
• Created: 13/Jun/24 22:09
• Updated: 22/Sep/24 16:53
• Resolved: 22/Sep/24 16:53

Description

Reading columnar mega pages that are not contiguous could be slowed by the number of requests as each range of contiguous pages will requested separately. In fact, doing SELECT * can be 2x faster than doing SELECT c1, c2, ..., cN  (where N is a double digit number) if each column initiate a cloud read request 

Such requests should be capped to a small number.