php - header Location very slow

[One]

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.

Has anyone seen this issue before ?

It uses a function like this :

tep_redirect(te p_href_link(FIL ENAME_CHECKOUT_ SUCCESS, '1', 'SSL'));
function tep_redirect($u rl) {
if ( (ENABLE_SSL == true) && (getenv('HTTPS' ) == 'on') ) { // We
are loading an SSL page
if (substr($url, 0, strlen(HTTP_SER VER)) == HTTP_SERVER) { //
NONSSL url
$url = HTTPS_SERVER . substr($url, strlen(HTTP_SER VER)); //
Change it to SSL
}
}

header('Locatio n: ' . $url);

tep_exit();
}
In my tests - I'll receive the confirmation email *beofre* I see the
success page in the browser!

As I say - I know the function eventually _works_ - but it was
interesting to see it work properly on the other server.

THANKS!

[J.O. Aho]

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.
--

//Aho

[Syl]

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 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!

[Jim Carlock]

"Syl" <da**********@g mail.comwrote:
: Actually - the database content gets inserted successfully, and
: then the confirmation email goes successfully - and then the
: redirect.
: 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!

Are you sending any output before the headers get sent?

Perhaps there's some HTML code at the top of the page before
your PHP code starts executing? The header("Locatio n: zzz...");
is not supposed to have any output at all before it's execution.
Then make sure there's an exit(); function right after the header();
function to make sure the script stops getting executed.

Hope this helps.

--
Jim Carlock
Post replies to the group.

[One]

Jim Carlock wrote:

"Syl" <da**********@g mail.comwrote:
: Actually - the database content gets inserted successfully, and
: then the confirmation email goes successfully - and then the
: redirect.
: 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!

Are you sending any output before the headers get sent?

Perhaps there's some HTML code at the top of the page before
your PHP code starts executing? The header("Locatio n: zzz...");
is not supposed to have any output at all before it's execution.
Then make sure there's an exit(); function right after the header();
function to make sure the script stops getting executed.

Hope this helps.

{ sigh }

THANK YOU for taking the time to post. Turns out it is a database
select issue.

I've re-posted ....... same problem, but differnet question! :-)

Jim Carlock
Post replies to the group.

[J.O. Aho]

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("Locatio n: 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