[jira] [Commented] (ASTERIXDB-3433) Number of cloud read requests could be excessive

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ASTERIXDB-3433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17856336#comment-17856336 ] 

ASF subversion and git services commented on ASTERIXDB-3433:
------------------------------------------------------------

Commit 44c938697aeb1a96ee8cee0c1742ca3c358fb5e3 in asterixdb's branch refs/heads/master from Ritik Raj
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=44c938697a ]

[ASTERIXDB-3433][STO] Capping read network call to cloud

- user model changes: no
- storage format changes: no
- interface changes: no

Details:

Merging page ranges to reduce the number of
network calls to object storage and also minimizing
the unwanted fetches.
The unwanted fetched pages are not pinned in the
buffer cache.

Change-Id: I343abcc5d2c2f1e65e8566e2a346e0a66da11d17
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18367
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Ritik Raj <ra...@gmail.com>
Reviewed-by: Wail Alkowaileet <wa...@gmail.com>


> Number of cloud read requests could be excessive
> ------------------------------------------------
>
>                 Key: ASTERIXDB-3433
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3433
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: STO - Storage
>    Affects Versions: 0.9.10
>            Reporter: Ritik Raj
>            Assignee: Ritik Raj
>            Priority: Critical
>              Labels: triaged
>
> 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.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)