Speed Up This Report Template

Given [login to view URL] and it's supporting code, optimize the CFML/SQL so that the page comes up in an IE 5.5 browser in the best, fastest, and cheapest manner, yet still displays all the info it did before. I will use an iOpus Internet Macros Batch File in the tray mode to perform the response time measurements. The macro looks like this: 'Save as C:\Program Files\InternetMacros3\Macros\[login to view URL] 'Run as "C:\Program Files\InternetMacros3\[login to view URL]" -macro Davez-ResponseTest -tray 'View results at C:\Program Files\InternetMacros3\Downloads\[login to view URL] SET !CHECKING YES SET !FILESTOPWATCH [login to view URL] STOPWATCH ID=total URL GOTO=[login to view URL] STOPWATCH ID=total I will run this 10 times and throw out the highest and lowest scores and take the average of the eight scores that are left. (Right now the average is 196.1166667 which is about an three minutes and sixteen seconds.) Now, If I can beat your score by modifying your deliverable, I will consider the job incomplete. I'm talking about things like combining the SQL into one record set, rearranging the cflooping, etc. P.S. I've added the SQL scripts for the database to the attached file. ## Deliverables 1) Complete source code of all work done. 2) Complete ownership and distribution copyrights to all work purchased. Test Data - if you run this SQL on the test database: | | SELECT | | | | ------ | ----------------------- | | | | [login to view URL] AS [Table Name], | | | | i.[rows] AS [Row Count] | | | FROM | | | | | sysobjects o INNER JOIN | | | | sysindexes i ON | | | | [login to view URL] = [login to view URL] | | | WHERE | | | | | ([login to view URL] = 'U') AND | | | | ([login to view URL] = 0) | This is the result set: | Table Name | Row Count | | Agency_Hours_Types | 170 | | Agency_Locations | 216 | | Cost_Centers | 204 | | Time_Scheduled | 55653 | | User_Control_Panel | 2392 | | Users | 2896 | ## Platform I am performing the tests on a Compaq Armada M700 (x86 Family 6 Model 8 Stepping 3) with 589,296 KB RAM running Microsoft Windows 2000 5.00.2195 Service Pack 2. The iOpus Internet Macros is V3.1 (IE Plug-In Build: 71) running from the tray using Internet Explorer (IE) Version 5.0.3502. The test data is run with Windows 2000 Server, Macromedia ColdFusion Server 5, and Microsoft SQL Server 2000.