I have 5 lines of code as a function that is called 100,000 times, there is a way to make the function inline so that I do not experience the overhead in PL / SQL. Oracle 9i is the version I'm using.
Update: Styling the code doesn't have much improvement, but I got 2 seconds. Now I am looking for an efficient version of the float data type in pl / sql. BINARY FLOAT is not working, NUMBER (10.5) is the one that is already in use.
You have determined that the function call overhead does not contribute much to the performance problem, so in this case, the attachment will not be useful.
, - SQL - SQL PL/SQL? , .
- - . PL/SQL . , .
PL/SQL. , PL/SQL, C, ++ Java. . .
Source: https://habr.com/ru/post/1742448/More articles:Does Rails 3 have a single route? - ruby-on-railsWhy am I losing sessions when working in StateServer mode? - asp.netWhat is a good template for binding a collection of WCF objects in Silverlight? - data-bindingWhy do some asp.net controls retain their state, although its EnableViewState property is false? - asp.netNeed a sorted dictionary designed to search for values with keys that are less or greater than the search value - dictionaryStandardServletContainer for target runtime in Eclipse - javaLink to DLLs built using older versions of .Net - referenceJava - abstract class, equals () and two subclasses - javaJQuery $ .unique () problem, i.e. - jqueryIs it safe to delete from SortedList during iteration - c #All Articles