hi all,
I've got a problem that requires your assistance, perhaps one of you has already run into this.
The script export.php writes a dispatch file from data stored in an oracle 8 database. It's started via a request done in a web interface ("click here to start data export"). this takes a lot of time, so I used:
system("./export.php >>/dev/null &");
this external call of a cgi php script starts the export process; the browser won't wait for a response.
and it works. but there's a nasty side effect: while the dispatch script is running, the oracle database seems locked - voilà the effect which I wanted to avoid by starting a background process!
I discovered other funny things:
other oracle databases on the same server (other "oracle users") can be accessed via their web interfaces. they are not locked.
if I start the export script in the shell (instead of via the web interface), the database that it's doing the queries on is not locked for the web interface!!
now I don't have a clue for this. what would you try?
thanks ...
matto
