I just recently went through some of the reports and old pages for one application that was "targeted" as doing this. What I found were older pages with a ton of queries on the page (eg one query that was looped through and then 5 subqueries run... when the first query has a ton of records and each sub can have unlimited recordsets inside, it's hairy).
Also, we had a lot of <cfloop query="..."> with individual <cfoutput> tags around the variabale names inside the loop. Those are a few of the things I found in working on these, there's probably more! HTH Hatton Philip Arnold - ASP wrote: >Something is up with one of our sites, but we're not sure what - it >*sometimes* takes the server to 100% CPU, memory and full CF requests > >Now, since the server has just under 50 sites, running 10 different bits >of technology, the smallest of which is about 6.5-7.5 thousand lines of >code, the largest of which is closer to 500 thousand lines of code > >One of our people here suggested that we get an "expert" in to look >through the code/sites and find out what's killing the server > >Has anyone got any idea as to what MM (or approved) would charge to come >in, stress test the sites and find the bit of code that's causing the >problem? Also some idea as to the time they would have to spend on it to >figure out what's going on > >I just want a ball-park - mainly to show how idiotic the idea is, when >we've been given 3 days to come up with the solution to the problem >while having to do our other work as well... > >Ta > >Philip Arnold >Technical Director >Certified ColdFusion Developer >ASP Multimedia Limited >Switchboard: +44 (0)20 8680 8099 >Fax: +44 (0)20 8686 7911 > >www.aspmedia.co.uk >www.aspevents.net > >An ISO9001 registered company. > >********************************************************************** >This email and any files transmitted with it are confidential and >intended solely for the use of the individual or entity to whom they >are addressed. If you have received this email in error please notify >the system manager. >********************************************************************** > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
