thanks for the ideas, I'll pass it on On Thu, Jun 25, 2009 at 5:06 PM, Rob Wolfe <rob.wo...@oraclegeeks.com>wrote:
> > One thing that I have noted (this is purely anecdotal, I have no numbers) > with functions that I write is that if I package up ones that are > temporally close to each other it seems to be somewhat quicker than if > they are standalone functions. I have no real rationale as to why this > would be the case unless it is due to the entire package getting cached > but that is a complete guess. > > David might have some hard numbers to back this up or refute it. > > One other thing that i have noticed is that once dblinks and user > functions get together performance goes straight to hell unless you are > VERY careful with what you are doing. I am not sure if that is due to > horrible configuration errors that we have made (possible), if I just suck > (also possible) or if it is something inherent in the beast. > > I take advantage of the parallel_enable hint/option/keyword whenever I > can as well. > > well, that is what little wisdom I can offer on this one. I think i shall > go have a drink in memory of Michael Jackson and Farah Fawcett... 47 > suddenly feels much older than it did yesterday. > > On Thu, June 25, 2009 13:42, Michael Moore wrote: > > A co-worker has the problem where he has created several functions that > he > > uses in SQL statements. His observation if that these functions, even > > though > > light weight, really slows down his SQL. > > We have speculated that this user-defined function is causing context > > switches which may be (at least in part) the cause of the slowness. > > > > So, my question is one of general usage hence the lack of an example. Is > > there some general feature, (compiled code for example) that can be > > applied > > to make SQL with embedded user-defined functions run faster? > > > > Mike > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
