[GitHub] [incubator-kyuubi] pan3793 commented on a change in pull request #1217: Zorder by and order by performance test

[GitBox <gi...@apache.org>]

pan3793 commented on a change in pull request #1217:
URL: https://github.com/apache/incubator-kyuubi/pull/1217#discussion_r726841578



##########
File path: docs/sql/z-order-benchmark.md
##########
@@ -177,7 +189,31 @@ select count(*) from conn_zorder where src_ip like '157%' and dst_ip like '216.%
 ```
 
 
-# benchmark result
+## benchmark result
+
+We have done two performance tests: one is to compare the efficiency of  Z-order Optimize and Order by Sort, 
+and the other is to query based on the optimized Zorder by data and Random data
+
+### Efficiency of Z-order Optimize and Order-by Sort
+
+**10 billion data and 1000 files and Query resource:200 core 600G memory**
+
+zorder by or order by only ip
+
+| Table               | row count      | optimize  time     |
+| ------------------- | -------------- | ------------------ |
+| conn_order_only_ip | 10,000,000,000 | 1591.99 s           |

Review comment:
       nit: format




-- 
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-unsubscribe@kyuubi.apache.org

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