Re: High Performance Server Side Programming - Which Language

nicholas.wakefield_at_gmail.com wrote:
> Hi,
>
> I have a static list of 100,000 values in an array, given a string I
> generate a hashcode and return an item from this array. I could join to
> another table but everything has to be done in a function.
>
> e.g select myFunc(field1) from myTable;

I've read the thread and now returned to your original post. I must confess to being confused. Waht does the array with 100,000 values and the hash code have to do with SELECT myFunct? It is far from clear.

And why 100,000 records? What "needs" 100,000 records at one time and why?

I'd be heading straight for a syntax like this:   BEGIN
   OPEN c;
   LOOP
     FETCH c BULK COLLECT INTO l_data LIMIT p_array_size;

• stuff here

     EXIT WHEN c%NOTFOUND;
   END LOOP;
   CLOSE c;

And set p_array_size to 100-500.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)