I forgot to mention that I timed the query all by itself using: <cfset session.beginTime = GetTickCount()> RUN QUERY HERE <cfset session.endTime = GetTickCount()> <cfset session.totalTime = session.endTime - session.beginTime> <cfdump var="#session.totalTime#" label="session.totalTime">
and my change caused the query to go from nearly seven seconds to just over two seconds. Bryan -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
