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 cfaussie@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
