Is the web server (IIS) giving you a timeout or is PHP? If it's PHP, you can change your max execution time with "set_time_limit" or I believe you can change it in your PHP.INI If it's IIS, then I'm very familiar with the error. Hah. I work doing data analysis and sometimes we deal with very large sets of data. I think our IIS servers timeout after 10 minutes or so (CGI Timeout..blah blah.. Script terminated). Indexing should definitely help on the database side. I don't see anything major with your script below (quick glance) except for the fact that you don't have a beginning or ending <TABLE> tag. But if all the data is sent, then IE is usually smart enough to make up for a coding faux pas like that. It's very odd that it runs fast on the server but times out on other systems unless the other systems are significantly lesser machines than the server. If it's a large table being sent, it can take a while to render the table on the client side. I guess what I'd do at this point is to try breaking it up a little. Toss a WHERE clause in there and limit your recordset. Put some breaks in the middle of the code to see if there's a certain segment of it that's causing issues (You could try installing Zend Studio client and server component and seeing if it's Profiler can show you were the bottleneck is.. It's pretty slick. http://www.zend.com free trial on the client and server). Good luck though.. It's going to end up being something silly that you're going to kick yourself for.. Hah.. -TG > -----Original Message----- > From: Andrew Staples [mailto:andrews@xxxxxxxxxx] > Sent: Thursday, May 13, 2004 2:26 PM > To: php-windows@xxxxxxxxxxxxx > Subject: Windows speed issue > > > I'm fairly new to php, hoping someone can help. I have a webpage that > displays records from a table. The problem is that viewing > the page on via > any browser other than a browser directly on the server gives > me a timeout > error. When run on the server, it's extremely fast. What am > I doing wrong? > (I tried indexing the city fields). This is on a win2003 server. > > The code is below. > > <? > // open database connection > db_connect(); > // generate and execute query > $query = "SELECT * FROM milage ORDER BY city"; > $result = mysql_query($query) or die ("Error in query: $query. " . > mysql_error()); > // if records present > if (mysql_num_rows($result) > 0) > { > // iterate through resultset > // print title with links to edit and delete scripts > while($row = mysql_fetch_object($result)) > { > ?> > <tr><td> > <font size="2"><b><? echo $row->city; ?></b></font></td> > <td> > <font size="2"><b><? echo $row->miles; ?></b></font></td> > <td><font size="2"><a href="edit.php?id=<? echo $row->cityid; > ?>">Edit</a></td> > <td><a href="delete.php?id=<? echo $row->cityid; > ?>">Delete</a></font></td> > </tr> > <? > } > } > // if no records present > // display message > else > { > ?> > <font size="-1">No Locations Listed</font><p> > <? > } > // close connection > ?> > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
