KevinyhZou commented on PR #8558:
URL: 
https://github.com/apache/incubator-gluten/pull/8558#issuecomment-2650203841

   ### 性能测试
   
   ```
   性能测试:测试数据量6千万行,分别执行三次,查看端到端执行时间
   
   get_json_object: select count(1) from test_tbl1 where 
get_json_object(get_json_object(d, '$.a'), '$.b') = 'c';
   优化前:53.194s, 52.18s, 51.603s
   优化后:24.894s, 25.042s, 24.724s
   
   and: select count(1) from test_tbl34 where id = 1 and d != 'axx' and d != 
'cxx' and d != 'zxx';
   优化前: 3.918s,4.106s,3.835s
   优化后: 3.123s, 3.303s, 3.288s
   
   or: select count(1) from test_tbl34 where id = 1 or d != 'axx' or d != 'cxx' 
or d != 'zxx';
   优化前:2.611s,2.765s, 2.484s
   优化后:2.3s, 2.409s, 2.283s;
   
   get_struct_field: select count(1) from test_tbl31 where d.e.d.y = 'y123';
   优化前:80.819s, 80.517s,83.3s
   优化后:80.885s, 80.108s, 81.121s;
   
   ```


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to