Posted by lawpoop on 07/10/07 19:26

Hello all -

I have a problem with a php page. I have a setup with Apache 2.0, PHP
5 and Postgres 8.1 on Debian 4.0. My script uses simplexml to parse
large xml files ( 8 files at 2-15 MB ea. ) and do inserts into the
database.

The problem is twofold. One, output on the parsing page seems to come
in starts and fits. I have a message to the user that gets echoed each
time parsing a file is finished; but these messages come all at once,
like two or three at a time. In other words, the message doesn't come
when the parsing is finished; they seem to build up. It's a simple
loop so I don't think the problem is in the program

Also, when I am going through the parsing loop for a set of files, the
rest of the site doesn't respond until the looping is over. The
parsing seems to basically stop all web serving.

How can I find out if the problem is with Apache, PHP, or Postgres?

[Back to original message]