Right but I'm not sure how grouping would work for this. I originally tried grouping but couldn't get it to output correctly. The master stored procedure pulls information from all the tables that have a one to one relationship with a student. (school/attendance/teacher/studentinfo) So the master includes 4 tables
The nested stored procedure holds all the data for each quarter (each quarter a student is graded on at least 60+ "skills") + each quarter there are comments for each student. The nested queries will run for each student and there may be 25 students pulled up at one time. So there's a total of 6 tables involved. Two of which have the multiple records.... Like I mentioned the queries themself run very quickly- it's when I add the loops for the output that they slow down. How can I re-arrange this? Thanks again -----Original Message----- From: Mark A. Kruger - CFG [mailto:mkruger@;cfwebtools.com] Sent: Friday, November 01, 2002 3:40 PM To: CF-Talk Subject: RE: Server Error-Urgent Janine, Yes - IMO this is pretty inneficient. If I'm looking at this correctly, You are using a master query (studentinformation) followed by one or more sub-queries - one for each row in the master query. This can probably be boiled down to a single query with a group by statement. This would eliminate the need for a nested loop (a cfoutput followed by query looping code). It would be usefule to see how many iterations (total) the inner loop create, then multiply it times the outer <cfoutput> recordcount. -mk -----Original Message----- From: Janine Jakim [mailto:jjakim@;albemarle.org] Sent: Friday, November 01, 2002 1:22 PM To: CF-Talk Subject: RE: Server Error-Urgent Activepdf is a good product- I agree. But the info it needs to spit out is pretty large- the stored procedures grab all the demographic data than all of the grades for each quarter. I have set up a <CFSET X = GetTickCount()> on the page in question. This particular section (and there are 4 of them- one for each quarter)is what seems to do it: <!---Output student info/teacher name/grade of student---> <CFOUTPUT QUERY="StudentInformation"> blah/blah <!---This is the bottleneck. Check to see if any grades are recorded for the quarter- if set the grade for activepdf (Tlkt)and if not set to ""---> <CFIF GradesQuarter3.RecordCount GTE 1> <CFLOOP INDEX="X" FROM="1" TO="#GradesQuarter3.RecordCount#"> <CFSET I= ToString(x)> <CFSET "Grade#I#Quarter3"=Tlkt.SetFormFieldData("Grade#I#Quarter3", "#GradesQuarter3.GradeForSubject[I]#", 0)> </CFLOOP> <CFELSE> <CFSET "GRADE#I#Quarter3"=Tlkt.SetFormFieldData("GRADE#I#Quarter3", "", 0)> </CFIF> <!---Repeat the same code above for each quarter...---> </CFOUTPUT> Is this code inefficient? Is there a betterway for me to do the same thing? -----Original Message----- From: Mark A. Kruger - CFG [mailto:mkruger@;cfwebtools.com] Sent: Friday, November 01, 2002 12:08 PM To: CF-Talk Subject: RE: Server Error-Urgent Janine, Active PDF is a COM and reputedly a good one - but it still introduces an external process into your page request. I'd start there. Why don't you post the code (or the cfoutput/looping part of it). -mk -----Original Message----- From: Janine Jakim [mailto:jjakim@;albemarle.org] Sent: Friday, November 01, 2002 10:42 AM To: CF-Talk Subject: RE: Server Error-Urgent I have a page that the queries run really quickly but when I set them to cfoutput loop/cfset to set for activepdf they slow to a crawl. I've been trying to figure out how to speed up this page. -----Original Message----- From: [EMAIL PROTECTED] [mailto:Douglas.Knudsen@;alltel.com] Sent: Friday, November 01, 2002 10:50 AM To: CF-Talk Subject: RE: Server Error-Urgent yes. Check your app. Do you have ultra long queries running? CFX tags? COM calls? I've seen this occuring when my Oracle server went down. Each request to the DB server eats up a thread until CF gets a response. Depending on your CF Admin settings, after x number of these unresponsive threads, your CF service gets restarted. Check your CF logs. Doug >-----Original Message----- >From: Janine Jakim [mailto:jjakim@;albemarle.org] >Sent: Friday, November 01, 2002 10:20 AM >To: CF-Talk >Subject: Server Error-Urgent > > >Hey has anyone seen this error? It is coming up regularly. >Any ideas where I should start to track down the problem? >Thanks for any insight. >J >Event Type: Error >Event Source: Service Control Manager >Event Category: None >Event ID: 7031 >Date: 10/31/2002 >Time: 6:00:50 PM >User: N/A >Computer: SCHOOLS >Description: >The Cold Fusion Application Server service terminated >unexpectedly. It has >done this 80 time(s). The following corrective action will be >taken in 0 >milliseconds: No action. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
