thanks porter, i took your advice and just set up a plain cfm page with four versions of that query.
1. no cfqueryparam all columns Time=31ms, Records=210 2. no cfqueryparam no txt columns Time=31ms, Records=210 3. cfqueryparam all columns Time=17297ms, Records=210 4. cfqueryparam no txt columns Time=16359ms, Records=210 turns out the cfqueryparam is giving me the problem here. any thoughts? i use cfqueryparam mostly everywhere as a rule and never ran into this problem. like, why here, why now? -alex >How much data is it returning? A few rows, a few dozen, thousands, >hundreds of thousands, millions. Sql2k5 just displays the results of the >query. CF transforms the query into a java.util.Map which results in >processing time on the CF server in addition to the processing time on >the SQL server for each query. Also adding an appropriate blockfactor >may speed this up as the driver may be sending one row at a time back to >CF instead of as much as it can. >Are you sure it is the query that is taking a long time or is it the >transformation of the query into whatever view you are making out of it? >Create a template with nothing in it but a cfquery call with the sql. Do >not dump it or anything and see whether the code that renders the query >results into something else is the culprit. > >If you can rule out CF processing as the issue, post the execution plan >created. Maybe you are missing indexes etc. Try running the query with >out using cfqueryparam if you are and compare the timing. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265816 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
