Scenario is as follows:
1, because smoke number by orcale stored procedure, the first edition version collation mapping is through the database to maintain computer, each time the query by introduced to find out the corresponding code value function parameters, such as large amount of data, the nested function spec is overmuch, can cause the query efficiency is very low, such as 50000 data can query more than an hour,
2, optimization as follows, to pick for the clock function, each table corresponding to a function, efficiency from 1 hour to 3 minutes completes, the disadvantage is that clock is not convenient to follow-up, are written in the function,
3, if there is a dynamically generated function, before each batch run through collation dynamically generated function codes, again through the stored procedure call function, so that achieve high maintainability, now with a run of efficiency is high; Offer advice or by other means, thank you master.