G-2220: Try to use PLS_INTEGER instead of NUMBER for arithmetic operations with integer values.
Critical
Efficiency
Reason
pls_integer
having a length of -2,147,483,648 to 2,147,483,647, on a 32bit system.
There are many reasons to use pls_integer
instead of number
:
pls_integer
uses less memorypls_integer
uses machine arithmetic, which is up to three times faster than library arithmetic, which is used bynumber
.
Example (bad)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
|
Example (good)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
|