Yes, CFQUERY reads all the content of the query. It gets a connection from the pool, queries the DB, retrieves all the data and finally returns the connection to the pool.
mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/3/9 Claude Schneegans <[email protected]>: > > Hi, > > I've always thought that all what CFQUERY was doing was to create some > connection to the database, and then the actual content of all records > would be read as needed during some loop on the result set. > > I have this statement on some Access database : > <CFQUERY NAME="getArmes" DATASOURCE="Armoriaux"> > SELECT armeId, armTexte > FROM armesArmoriaux > </CFQUERY> > <CFOUTPUT>getArmes.recordCount = #getArmes.recordCount#<BR> > cfquery.ExecutionTime = #cfquery.ExecutionTime#<BR></CFOUTPUT><CFABORT> > > The query semms to take for ever. Actually, the output says: > getArmes.recordCount = 303203 > cfquery.ExecutionTime = 614469 > > More than 10 min. just to settle a result set? That does not make sense. > Ok, armTexte is a memo field, but is CFQUERY supposed to read all of them? > > If I run the same query directly from Access, it runs so fast, I cannot > even measure the time it takes. > > So, what the heck CF is doing within CFQUERY? Read all content? That > does not make sense. > Is the problem with CF, or the ODBC drive ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320240 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
