Worst project I ever saw: ONE HUNDRED EIGHTY SEVEN examples of dynamic SQL in the code.
ONE.
HUNDRED.
EIGHTY.
SEVEN.
And, in the landing page, TWENTY includes of a javascript library. The same library. TWENTY TIMES. A round-trip for each include.
And people wondered why the landing page took 45 seconds to load.
LOL
Dynamic SQL is a bit slower, but not horribly so. I’ve actually dug into the ORAthis, ORAthat which Oracle uses for its internal interface, and it ends up boiling down to something that has to be parsed at run time anyhow.
I know less about Javascript — that system apparently doesn’t understand when you’re asking to load the same code more than once, and optimize it for you?