Posted by Colin McKinnon on 10/05/06 20:03

Geoff Muldoon wrote:

>
> Oracle 10g RAC on Linux, with an end-user interface via Apache/PHP/AdoDB
> on a separate Linux box.
>
<snip>
>
> I am considering creating a "master" PL/SQL stored procedure which would
> use the Oracle DBMS_SCHEDULER package to run a nearly-immediate job as a
> "background" (to the PHP interface) process.
>
> Is this the way to go, or are there other better solutions that I am
> overlooking?
>

You mean apart from
1) not using materialized views
2) ditching Oracle and rewriting with just about any other DBMS ?
;)

You could look at the thread started slightly later today in comp.lang.php
'process a BIG string' but using the DBMS scheduler is probably the
practical way to go.

C.

[Back to original message]