Hi, I'm currently rebuilding a site previously constructed using Lasso/Filemaker. I'm using PHP5/MySQL4/PEAR::DB and Smarty. The site holds course content information for universities and colleges. My first page after logging on displays courses for the user. This lists relevant courses, their status and some stats for items that require attention. This involves one SQL query to a course table containing 3,100 records, and in my sample returned 4 records. The stats and status data require another 12 SQL queries to a transaction table containing over 32,000 records. In both these tables, I have indexed all the columns. My testing this weekend is producing disappointing results with the page taking between 20 and 50 seconds to appear. I'm running this on a fairly fast laptop with XP, IIS5, using the ISAPI method. The deployment is going to be on slower NT servers. Does anyone have any tips to improve performance? MTIA George -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
