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 -~----------~----~----~----~------~----~------~--~---
