zorantica / plsql-qr-code

Oracle PL/SQL Package and APEX plugin for QR Code Generation
MIT License
52 stars 20 forks source link

Upfront initialization of reference tables #12

Open kukimik opened 2 months ago

kukimik commented 2 months ago

This is the easiest and probably the least controversial among changes announced in #10.

This PR moves the initialization of the lookup tables to the moment the package is initialized. It improves the performance when the package is called multiple times in a single session. As the data in the reference tables does not change during execution, it makes little sense to fill these variables anew every time a QR code is generated.