Re: Oracle + PHP + long process

From: Colin McKinnon <colin.thisisnotmysurname_at_ntlworld.deletemeunlessURaBot.com>
Date: Thu, 05 Oct 2006 20:03:58 GMT
Message-ID: <OydVg.263$Fx4.148@newsfe1-gui.ntli.net>

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. Received on Thu Oct 05 2006 - 15:03:58 CDT