Re: time out problem -- WEB400

You are right, Matt, thanks! The log specifically says that we timed
out. So now my question is: what do I change in the php.ini file? I see
a lot of "time out" directives, some of which seem to relate to sockets,
MySQL, and other stuff. Which do I change? Also, why do you say that I
probably do not want this to be above a minute or two? It is possible
that I will be getting as many as 10,000 records, and will be calling an
API from a mailblast site (called MailChimp), and this might take more
than a minute or two.

Larry Kleinman
Kleinman Associates, Inc.
212-949-6469
203-255-4100

MattLavinder@xxxxxxxxxxxxxxxxxxx
Sent by: web400-bounces@xxxxxxxxxxxx
07/12/2010 11:37 AM
Please respond to
Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>

To
Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
cc
web400@xxxxxxxxxxxx, web400-bounces@xxxxxxxxxxxx
Subject
Re: [WEB400] time out problem

Check your PHP error log is. The location is specified in your php.ini.
If it isn't specified, the messages will be in your Apache log. If you
see
a "Maximum execution time of XX seconds exceeded then PHP timed out. You
can increase the PHP timeout in your php.ini file. The default is 30
seconds. You probably don't want this to be above a minute or two. There
will most likely be a message from the SQL Server extension if the
time-out
is happening there.

web400-bounces@xxxxxxxxxxxx wrote on 07/12/2010 10:23:51 AM:

[image removed]

[WEB400] time out problem

Larry Kleinman

to:

web400

07/12/2010 10:52 AM

Sent by:

web400-bounces@xxxxxxxxxxxx

Please respond to Web Enabling the AS400 / iSeries

First my apologies for posting this previously as a response to a
completely unrelated post. I didn't realize that that confused the

server

as well as some mail clients.

I am reposting this now, hopefully correctly, since I got no response to
the original post, I suspect due to my incorrect posting.

Hi folks - Table NAME (in the script below) has about 10,000 rows in it.
When I run it using ZEND CORE, all I get is the word "top" showing up.

(It

takes a minute or so). When I run it with some additional selection
criteria, so that I get about 7500 rows, it works fine - the "echo

$count"

statement at the end displays the count. How can I tell whether this is

time out in getting the data from the SQL server, or in the Apache or

Zend

server, or in the browser?

<html>
<head></head>
<body>

<?php
echo "top";

$conn = mssql_connect('FBC_DEV_106','xxx','xxxx');
if ($conn) {
mssql_select_db("FBC_DEV_106");

$query = "SELECT * from NAME ";

$sql_result = mssql_query($query);

if($sql_result) {
while ($array = mssql_fetch_array($sql_result)) {
$count = $count + 1;
}
echo $count;

}

}

?>

</body>
</html>

Larry Kleinman
Kleinman Associates, Inc.
212-949-6469
203-255-4100
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
______________________________________________________________________

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
______________________________________________________________________