Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unexplainable: "Beautified" code runs slower
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_technology
:)
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_users_ta.htmlReceived on Mon Oct 01 2007 - 19:27:59 CDT
![]() |
![]() |