Speed Up This Report Template Again

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 !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 [url removed, login to view] 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.

## 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 | |

| | ------ | ----------------------- |

| | | [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 |

## 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 [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.

Habilidades: Cold Fusion, Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Ver mais: template source file, service report template, php goto url, job rentacoder, iim a, id pack, family id, program template, cheapest template, best rentacoder, 2000 seconds, p sql, microsoft macro, x86, stepping, sql server scripts, sql database report, speed up, speed data, report sql, rentacoder, page speed, iim, php scripts pack, url internet explorer windows

Acerca do Empregador:
( 6 comentários ) United States

ID do Projeto: #2954306

4 freelancers estão ofertando em média $286 para este trabalho


See private message.

$425 USD in 30 dias
(138 Comentários)

See private message.

$126.65 USD in 30 dias
(33 Comentários)

See private message.

$420.75 USD in 30 dias
(4 Comentários)

See private message.

$170 USD in 30 dias
(0 Comentários)