What version of Coldfusion are you using? If you are using pre Coldfusion 8, then might I suggest these 2 products Fusion-Reactor & Fusion-Debug.
If you are using Coldfusion 8, then might I suggest using the Monitor and Line Debugger. These 2 options can be invaluable towards debugging and optimising your code. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 9015 8628 Mobile: 0404 998 273 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of nedlud Sent: Friday, 23 May 2008 2:27 PM To: cfaussie Subject: [cfaussie] Re: frustrated CF newbie For what it's worth, I seem to have resolved this issue by optimising some of the sql queries. I still can't claim to understand exactly what the problem was, but by using *a lot* of cfdump statments, I found that a particular query occasionaly ran *way* slow (we are using MySQL 4.1). Adding an index, and optimising some queries to use joins instead of sub-queries seems to have made the problem go away. At least I can say it doesn't seem to have been my coldfusion code that was at fault. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
