Given [url removed, login to view] 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\[url removed, login to view]
'Run as "C:\Program Files\InternetMacros3\[url removed, login to view]" -macro Davez-ResponseTest -tray
'View results at C:\Program Files\InternetMacros3\Downloads\[url removed, login to view]
SET !CHECKING YES
SET !FILESTOPWATCH [url removed, login to view]
URL GOTO=[url removed, login to view]
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 you get an average of greater than 90 and 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.
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 | |
| | ------ | ----------------------- |
| | | [url removed, login to view] AS [Table Name], |
| | | i.[rows] AS [Row Count] |
| | FROM | |
| | | sysobjects o INNER JOIN |
| | | sysindexes i ON |
| | | [url removed, login to view] = [url removed, login to view] |
| | WHERE | |
| | | ([url removed, login to view] = 'U') AND |
| | | ([url removed, login to view] = 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 |
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 [url removed, login to view] Service Pack 4. The iOpus Internet Macros is [url removed, login to view] (IE Plug-In Build: 170) running from the tray using Internet Explorer (IE) Version 6.0.2800.1106.
The test data is run with Windows 2000 Server, Macromedia ColdFusion Server 5, and Microsoft SQL Server 2000.