Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Global.asa

Author  Topic 

Rockn
Starting Member

10 Posts

Posted - 2001-10-12 : 13:16:00
Our developer (no longer developing..thank god) created an application in ASP that tracks client intakes and referrals. One page in particular is a huge resource hog and I would like some advice on one feature on the page in question. The page is pretty straight forward except for one area...two dropdown lists. They are built from two tables for agencies and needs. The code that creates them comes from the global.asa file(why they did that is beyond me). The global.asa creates an array for each pulldown list. Opening and updating this page casues the CPU useage to go to over %100 for over 2 seconds and I am wondering if there si a better way to code this. Would a server side include or directly coding it in the page be more efficient? Any advice would be great!! TIA

   

- Advertisement -