Re: Tuning PL/SQL

I worked on a project that had the need for code running many times a day by many people that would do a lot of looping and a lot of number crunching in the looping (mostly just add/subtract/divide/multiply/rounding).

We were considering C and PlSql (back in 1993).

The use of PlSql worked great for this!

We loaded the data in arrays when possible and made sense (smaller tables/query-results and accessed often in loops - these days you might just pin these tables in memory) .

I would also suggest using a package . Sharing arrays between procedures within 1 package is easy (no coding - automatically shared) when you declare the arrays at the beginning of the body before any procedures or functions.

-- 

"Daniel Roy" <danielroy10_at_hotmail.com> wrote in message
news:1b061893.0305161223.39f2d13e_at_posting.google.com...


> Bare also in mind that each language has its specialty, and PL/SQL is

> not a good choice when doing lots of calculations (use C for this). If

> on 9i, you can also run the native code (instead of interpreting the

> code, I think), which is supposedly faster.

>

> Daniel