Hi Jeff,
>1. Is the maxrows attribute in the <cfquery> tag or the <cfoutput> tag?
It is in the cfquery tag of the news rule. (The query in question is the
qGetNews query from the execute method of the ruleNews.cfc.)
>2. Is it the query or the page that's taking so long to render?
The query. According to the debug output, the query is taking nearly
17000 ms. The strange thing is this dynamic query is run again on a
subsequent call to ruleNews.execute(), with different data, and it only
takes 47 ms. If I run the problem query (copy and pasted from the debug
output) outside of FarCry it takes anywhere from 0 - 20 ms.
>4. Can you give a shortened version of your query and
>Coldfusion output code?
Again, this is the qGetNews query from the ruleNews.cfc. Because this is
part of a rule, output is accomplished via the container.cfc's populate
method. The longest any call to container.populate() is taking is 700
ms. (A little on the slow side, but acceptable for now.)
Here is the exact query that is being executed:
SELECT DISTINCT type.objectID, type.publishDate, type.label
FROM refObjects refObj
JOIN refCategories refCat ON refObj.objectID = refCat.objectID
JOIN dmNews type ON refObj.objectID = type.objectID
WHERE refObj.typename = 'dmNews'
AND refCat.categoryID IN ('146BAA5B-AB9C-95E9-F85002800CB851D7')
AND type.status IN ('approved')
AND publishdate <= {ts '2004-07-07 13:26:11'}
AND expirydate >= {ts '2004-07-07 13:26:11'}
ORDER BY type.publishDate DESC, type.label ASC
Thanks,
--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/
