[GitHub] [incubator-doris] zenoyang commented on pull request #8193: [refactor](storage)(olap) improve pageDecoder using final keyword

[GitBox]

zenoyang commented on pull request #8193:
URL: https://github.com/apache/incubator-doris/pull/8193#issuecomment-1048718553


   ### Q2.1 flat table query:
   ```sql
   SELECT
       sum(LO_REVENUE),
       (LO_ORDERDATE DIV 10000) AS year,
       P_BRAND
   FROM lineorder_flat
   WHERE P_CATEGORY = 'MFGR#12' AND S_REGION = 'AMERICA'
   GROUP BY
       year,
       P_BRAND
   ORDER BY
       year,
       P_BRAND;
   ```
   result:
   ```
   before PR test:
   - Total: 1s287ms
            - BlockLoadTime: 6s779ms
            - BlockLoadTime: 6s677ms
            - BlockLoadTime: 6s699ms
            - BlockLoadTime: 6s787ms
            - BlockLoadTime: 6s801ms
            - BlockLoadTime: 6s759ms
            - BlockLoadTime: 6s729ms
            - BlockLoadTime: 6s772ms
   avg: 6750.375ms
   
   after PR test:
   - Total: 1s353ms
            - BlockLoadTime: 6s897ms
            - BlockLoadTime: 6s838ms
            - BlockLoadTime: 6s850ms
            - BlockLoadTime: 6s881ms
            - BlockLoadTime: 6s965ms
            - BlockLoadTime: 6s878ms
            - BlockLoadTime: 6s941ms
            - BlockLoadTime: 6s848ms
   avg: 6887.25ms
   ```
   
   ### Q2.2 flat table query:
   ```sql
   SELECT
       sum(LO_REVENUE),
       (LO_ORDERDATE DIV 10000) AS year,
       P_BRAND
   FROM lineorder_flat
   WHERE P_BRAND >= 'MFGR#2221' AND P_BRAND <= 'MFGR#2228' AND S_REGION = 'ASIA'
   GROUP BY
       year,
       P_BRAND
   ORDER BY
       year,
       P_BRAND;
   ```
   result:
   ```
   before PR test:
   - Total: 1s408ms
            - BlockLoadTime: 7s622ms
            - BlockLoadTime: 7s674ms
            - BlockLoadTime: 7s714ms
            - BlockLoadTime: 7s552ms
            - BlockLoadTime: 7s596ms
            - BlockLoadTime: 7s752ms
            - BlockLoadTime: 7s870ms
            - BlockLoadTime: 7s782ms
   avg: 7695.25ms
   
   after PR test:
   - Total: 1s449ms
            - BlockLoadTime: 7s738ms
            - BlockLoadTime: 7s774ms
            - BlockLoadTime: 7s654ms
            - BlockLoadTime: 7s783ms
            - BlockLoadTime: 7s751ms
            - BlockLoadTime: 7s768ms
            - BlockLoadTime: 7s764ms
            - BlockLoadTime: 7s825ms
   avg: 7757.125ms
   ```
   
   ### Q2.3 flat table query:
   ```sql
   SELECT
       sum(LO_REVENUE),
       (LO_ORDERDATE DIV 10000) AS year,
       P_BRAND
   FROM lineorder_flat
   WHERE P_BRAND = 'MFGR#2239' AND S_REGION = 'EUROPE'
   GROUP BY
       year,
       P_BRAND
   ORDER BY
       year,
       P_BRAND;
   ```
   result:
   ```
   before PR test:
   - Total: 1s217ms
            - BlockLoadTime: 6s47ms
            - BlockLoadTime: 6s138ms
            - BlockLoadTime: 6s360ms
            - BlockLoadTime: 6s399ms
            - BlockLoadTime: 5s877ms
            - BlockLoadTime: 6s70ms
            - BlockLoadTime: 6s293ms
            - BlockLoadTime: 6s233ms
   avg: 6308.75ms
   
   after PR test:
   - Total: 1s211ms
            - BlockLoadTime: 6s362ms
            - BlockLoadTime: 6s276ms
            - BlockLoadTime: 6s277ms
            - BlockLoadTime: 6s347ms
            - BlockLoadTime: 6s363ms
            - BlockLoadTime: 6s328ms
            - BlockLoadTime: 6s299ms
            - BlockLoadTime: 6s622ms
   avg: 6359.25ms
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org