Actually, the performance is pretty good. The query of query doesn't touch the db, all in memory, so it's almost exclusively web server. But you're right, this many nested loops is never a good thing. I'll probably end up rewriting some of the code. I guess not being able to get past this problem would be a good reason to start rewriting.
-----Original Message----- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 4:48 PM To: CF-Talk Subject: RE: query of query, nested loops... I have not, sorry. This sounds like this could turn into a resource intensive script (lots of nested loops and queries). Is there anyway you can consolidate the queries (recursive sql, self joins, cfoutput grouping)? Eric -----Original Message----- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 4:43 PM To: CF-Talk Subject: query of query, nested loops... Hello all, Here is my process: I query the database in query1. I query query1, call it query2. Loop through query2. While in the query2 loop, I query query1 again, call it query3. Loop through query3. While in the query3 loop, I query query1 again, call it query4. Are you seeing the pattern? Rather than paste my code (lots), I'll ask the blanket question: Has anybody heard of problems with cf5's query of query and nested loops? What happens is in the third level deep of these nested loops, the query of query acts as if it's ignoring my where clause and pulls more records than it's supposed to. Anybody hear of this before? Thanks... Ryan Ryan J. Pieszak Applications Engineer Ziphany, LLC. (716) 510-0379 www.ziphany.com ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
