| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Unexplainable: "Beautified" code runs slower
ivl5_at_hotmail.com schrieb:
> On Oct 2, 10:27 am, joel garry <joel-ga..._at_home.com> wrote:
>> On Oct 1, 5:08 pm, i..._at_hotmail.com wrote: >> >> >> >>> On Oct 2, 7:09 am, "userjohn" <userj..._at_mailinator.com> wrote: >>>> "Maxim Demenko" >>>>> Yet one possibility - go to Debugger tab page, disable the "Add debug >>>>> information when compiling" and recompile. >>>> hey Maxim, I think you saved me from insanity ! >>>> I've been using PSD for 7 years and shame on me, never used the debugger >>>> so I'm clueless to the settings. >>>> So yes, "Add debug information when compiling" was checked in my Preference. >>>> So I uncheck the option - recompile the code, run it - WHOLEY COW ! it ran >>>> faster than it ever has !: >>> You have a new problem then: why does it run faster, shouldn't it be >>> the same? :) >> No. http://en.wikipedia.org/wiki/Observer_effect#Use_in_information_techn... >> :)http://tkyte.blogspot.com/2007/09/tuning-with-sqltracetrue.html;)
>> jg >> -- >> @home.com is bogus.http://www.informationweek.com/blog/main/archives/2007/09/iphone_user...
The "problem" as i see it is, that a lot of people don't realize the fact (i speak now from my personal experience), that code don't belong in the database, it belong in the source code repository. If the code will be checked out, reformatted, beautiied, whatever , then checked in and again deployed in the database by means of sqlplus ( because the sqlplus is the only reference client one can rely on) - such issues would not even arise, because you'll never see in the source code things like "ALTER PACKAGE COMPILE DEBUG". Such habits (not using code repository) may cause a lot of problems, that was only example of one of many possibilities...
Best regards
Maxim Received on Tue Oct 02 2007 - 02:01:21 CDT
 |
 |