[GitHub] [shardingsphere] FlyingZC commented on pull request #28591: Optimize oracle select statement parsing speed

Tue, 26 Sep 2023 01:10:43 -0700 


FlyingZC commented on PR #28591:
URL: https://github.com/apache/shardingsphere/pull/28591#issuecomment-1735043084

   Before: 6000 ms
   
   After: 169 ms
   
![image](https://github.com/apache/shardingsphere/assets/19788130/804ebcfe-b375-4a41-b48d-3b2c193b4afa)
   
   sql case:
   ```sql
   SELECT t_order AS ID, 1, 1102
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110201
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110205
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110206
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110207
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110208
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110203
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110204
   FROM dual
   union all
   SELECT t_order AS ID, 1, 202004280002
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110202
   FROM dual
   union all
   SELECT t_order AS ID, 1, 202005081039
   FROM dual
   union all
   SELECT t_order AS ID, 1, 220506151002981
   FROM dual
   union all
   SELECT t_order AS ID, 1, 1103
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110303
   FROM dual
   union all
   SELECT t_order AS ID, 1, 11030399
   FROM dual
   union all
   SELECT t_order AS ID, 1, 11030302
   FROM dual
   union all
   SELECT t_order AS ID, 1, 11030301
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110309
   FROM dual
   union all
   SELECT t_order AS ID, 1, 11030902
   FROM dual
   union all
   SELECT t_order AS ID, 1, 11030901
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110314
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110321
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110308
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110318
   FROM dual
   union all
   SELECT t_order AS ID, 1, 220214151002708
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110306
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110320
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110323
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110307
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110310
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110322
   FROM dual
   union all
   SELECT t_order AS ID, 1, 200817151000342
   FROM dual
   union all
   SELECT t_order AS ID, 1, 200817151000341
   FROM dual
   union all
   SELECT t_order AS ID, 1, 200817151000344
   FROM dual
   union all
   SELECT t_order AS ID, 1, 200817151000343
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110324
   FROM dual
   union all
   SELECT t_order AS ID, 1, 1660209
   FROM dual
   union all
   SELECT t_order AS ID, 1, 190118151000101
   FROM dual
   union all
   SELECT t_order AS ID, 1, 221122151003614
   FROM dual
   union all
   SELECT t_order AS ID, 1, 221122151003613
   FROM dual
   union all
   SELECT t_order AS ID, 1, 220309151002802
   FROM dual
   union all
   SELECT t_order AS ID, 1, 221024151003571
   FROM dual
   union all
   SELECT t_order AS ID, 1, 221024151003573
   FROM dual
   union all
   SELECT t_order AS ID, 1, 221024151003578
   FROM dual
   union all
   SELECT t_order AS ID, 1, 221024151003577
   FROM dual
   union all
   SELECT t_order AS ID, 1, 221024151003572
   FROM dual
   union all
   SELECT t_order AS ID, 1, 221024151003576
   FROM dual
   union all
   SELECT t_order AS ID, 1, 221024151003574
   FROM dual
   union all
   SELECT t_order AS ID, 1, 221128151003618
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110311
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110312
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110313
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110317
   FROM dual
   union all
   SELECT t_order AS ID, 1, 220331151002857
   FROM dual
   union all
   SELECT t_order AS ID, 1, 220920151003515
   FROM dual
   union all
   SELECT t_order AS ID, 1, 220920151003518
   FROM dual
   union all
   SELECT t_order AS ID, 1, 221122151003612
   FROM dual
   union all
   SELECT t_order AS ID, 1, 220402151002865
   FROM dual
   union all
   SELECT t_order AS ID, 1, 220414151002914
   FROM dual
   union all
   SELECT t_order AS ID, 1, 220419151002931
   FROM dual
   union all
   SELECT t_order AS ID, 1, 220523151003024
   FROM dual
   union all
   SELECT t_order AS ID, 1, 220601151003076
   FROM dual
   union all
   SELECT t_order AS ID, 1, 220607151003084
   FROM dual
   union all
   SELECT t_order AS ID, 1, 110319
   FROM dual
   union all
   SELECT t_order AS ID, 1, 11031903
   FROM dual
   union all
   SELECT t_order AS ID, 1, 11031908
   FROM dual
   union all
   SELECT t_order AS ID, 1, 11031905
   FROM dual
   union all
   SELECT t_order AS ID, 1, 11031901
   FROM dual
   union all
   SELECT t_order AS ID, 1, 11031902
   FROM dual
   union all
   SELECT t_order AS ID, 1, 11031904
   FROM dual
   ```


-- 
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]

Reply via email to