Re: High Performance Server Side Programming - Which Language

Nicholas, any time that you invoke a plsql function in a sql select there is a big performance hit. The basic rules of thumb are don't invoke a function in a select if you can avoid it, if you do have to invoke a function try very hard to use the oracle provided "extentions to sql" functions rather than a sql function. If you have to use a function outside of "sql extended" then go for plsql rather than java if you can ... etc.

Instead of containing things in an array perhaps you really want to use an oracle hash table where you can use oracle to "randomize" or hash to a block based on how you define the hash. Performance in that case will be much better.

Try checking in the asktom.oracle.com site and do some searches using hash and select you should fine some helpful information. Received on Thu Jun 02 2005 - 19:09:49 CDT