Not sure if this will help, but I have seen a significant improvement in speed, by switching from using normal mysql_connect() to mysql_pconnect() Using a persistent connection helped me, you may need to adjust some setting for it to work affectively -----Original Message----- From: Andrew Staples [mailto:andrews@xxxxxxxxxx] Sent: Thursday, May 13, 2004 8: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 ~~~~ Scanned by neroAntiVirus.com (19:28:11 SPITFIRE) ~~~~ -------------------------------------------------------------------- Disclaimer This e-mail transmission contains confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
