RE: [PHP-WIN] Windows speed issue

-----Original Message----- From: Gryffyn, Trevor [mailto:TGryffyn@air-cargo-inc.com] >>Good luck though.. It's going to end up being something silly that you're going to kick yourself for.. Hah.. Yes, kicks are in order. I changed from using php4isapi.dll to php.exe, and instant success. Here I thought the dll would be faster...(using php 4.3.6). I'd be interested in others feedback. Andrew > -----Original Message----- > From: Andrew Staples [mailto:andrews@ltinet.net] > Sent: Thursday, May 13, 2004 2:26 PM > To: php-windows@lists.php.net > Subject: [PHP-WIN] 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 > ?> > > --