For my company I am basically creating a web based report using ASP and SQL Server.
Each row of the report contains a month-to-date total and then loops through the weeks displaying the totals for each week. (the raw data is in daily form)
Currently ten weeks are being displayed. Therefore each row has 11 database calls (10 weeks + month-to-date). There are 50 rows on the page.
The page takes close to five minutes to load.