The first thing I'd do would be to try to identify the query(ies) that's bottlenecking the process ... It's possible that there's just one that's holding everything up, then you can work on optimizing just the slow one (or ones). You may also want to try combining or reworking the 12 queries you have to make the the one transaction table ... That seems like a lot to me and I would think there's a better way to get the information you're after involving less than 12; of course I could be dead wrong on that assumption since I don't know anything about the data you're after (or the transaction talbe you're getting it from either for that matter;) -----Original Message----- From: George Pitcher [mailto:george.pitcher@xxxxxxxxxxx] Sent: Sunday, November 07, 2004 5:54 AM To: php-windows@xxxxxxxxxxxxx Subject: Performance question? 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 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
