Posted by J.O. Aho on 12/31/06 06:42

Syl wrote:
> J.O. Aho wrote:
>> One wrote:
>>> Hi guys - I have a problem after a client clicks a Confirm button on a
>>> form - the form processes the data, inserts into a database, and then
>>> redirects using header Location.
>>>
>>> I have tested this on two different Linux/Apache servers. One works
>>> perfectly, the other takes about 90 seconds to redirect.
>> I suggest you use a small function that writes to a log file a small text
>> message and the time stamp, set this before everything you are going to do,
>> this way you see where the slowness comes from, can be that the second servers
>> connection to the database is so bad it takes it a lot longer to send the data
>> to the database which makes a delay before it come to the line where it does
>> the redirect.
>>
>>
>
> Hi Aho - thanks for the reply.
> Actually - the database content gets inserted successfully, and then
> the confirmation email goes and successfully - and then the redirect.

I wasn't questioning that the data wasn't inserted into the database, but that
the connection to the database is slow. If there had been trouble with
inserting into the database, it had been more likely you got some error
message displayed on the web page without redirection.


> I know it is the redirect because I query the db and the content is
> there, and I also recieve the email - all beofre I see the success page!

If you are using header("Location: http://example.net"), and it takes time
before you get redirected, then the fault is before the header statement, as
this redirection don't allow delay (it's possible to make redirection with
delay, but then you need to set the delay in seconds and would affect the
script in both servers).

In your reply to Jim you say it's a select statement that causes the problem,
then you may better ask your question at alt.php.sql than a general php
newsgroup or a Unix newsgroup, where they may not be that interested in
answering when it comes to irrelevant things like php and Linux.

--

//Aho

[Back to original message]