[ cf-dev ] query of query performance (CF5)

[Mark Woods]

I'm running a simple select on an query which has about 18,000 records, and 
it's killing my server (the query is taking 4-5 seconds to return 
anything). Is query of query performance a known issue with CF5?

<cfquery name="qCheckExists" dbtype="query">
        
        SELECT cacheName
        FROM qWasCached
        WHERE cacheName = '#cacheName#'
                AND type = '#attributes.type#'
                AND id = '#attributes.id#'
                AND label = '#attributes.label#'
                AND keywords = '#attributes.keywords#'
</cfquery>	

--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]