assuming ID is a primary key, could this not be simplified to just: WHERE id = '#attributes.id#'
or would that be over-simplification? Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- Mark Woods <[EMAIL PROTECTED] To: [EMAIL PROTECTED] e.ie> cc: Subject: [ cf-dev ] query of query performance (CF5) 03/06/2003 10:21 Please respond to dev 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] -- ** 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]
