Nathan,
1. Is the maxrows attribute in the <cfquery> tag or the <cfoutput> tag?
2. Is it the query or the page thats taking so long to render?
If its the query, then ignore question 3.
3. Are you looping over <cfoutput> tags? depending on your output code, sometimes wrapping a <cfoutput> around the <cfloop> tag will give better performance (otherwise the CF server has to render (start & stop) the tag for each loop when it may have not been necessary.
4. Can you give a shortened version of your query and Coldfusion output code?
Regards,
Jeff Coughlin Web Application Developer [EMAIL PROTECTED] http://www.jeffcoughlin.com/
Nathan Mische wrote:
I have a page with two news rules in separate containers. In the first
news rule the qGetNews query is taking 16000 - 17000 ms to execute. The
second news rule's qGetNews query only takes 150 ms at most.
I copied the qGetNews query from the first news rule into a new template and ran it outside of FarCry. There the query only takes about 15 ms on average. Has anyone seen anything like this before? Any pointers on where to look to track down the problem?
I'm running FarCry b211, on Windows 2003 with Oracle 9i.
TIA,
--Nathan
--- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
