OK folks, try and help me with this one.
I have a PHP script that loads records from a flat file on the webserver into a MySQL database. The script initially displays a HTML page with a start button and when it finishes displays a further HTML page with a confirmation message.
For a small number of records this works just fine. When the records get into the hundreds or thousands things start to behave a bit peculiarly. After pressing the start button the script runs for about twenty seconds and then the screen displays a connection timed out message as generated by a HTTP 504 error, BUT the script continues running in the background (this is verified by checking the database very few seconds and seeing the count growing on the table).
This behaviour is made even weirder when the job is triigered to run from a dialup connection. The timeout still occurs, but after minutes rather than 20 seconds as with a DSL/cable connection. How can this be when the script is running on the server from a file on the server?
Any help or advice would be appreciated as this is bugging me. For information the server in question is a Cobalt RAQ 3 running RH linux 5, PHP 4.05 and MySQL 3.23. The browser is IE5.5 if that is any help.
HELP!
Fes.