Performance of 3GL callouts from database?

Hi everyone.

We are considering using a new Oracle 8 feature - namely the calling of 3GL procedures (C) from the database. Has anyone used this extensively and what's the performance like?

We have an application that would have up to 100 concurrent users, each running queries that would require a callout to C.
1)Is a separate process started for each user? 2)How much memory does each one consume (i.e. is it like the dedicated shadow process required for each user session against the database)?
3)Are callbacks to the database treated as the same session as the calling session?
4) Suppose an Oracle Report is being run, that is doing a full

   scan on a 2 million row table, and makes a call to the external    procedure for each individual record, does this require the    opening and closing of the external process 2 million times    and lead to serious performance implications?

  In other words, a bit like the context switching that   occurs when going between SQL and PL/SQL.

All warstories and ideas are appreciated. Thanks

Coakleyj

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 14 1999 - 09:04:05 CDT