On Sun, Mar 8, 2009 at 11:42 PM, Claude Schneegans wrote: > 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.
That would be impossible for CF to do because: - if the resultset were never used the query would never be run on the server; - if the resultset were used multiple times the query would be run multiple times on the server; - the number of records would be unknown. If you want that, declare a cursor and deal with those consequences yourself. > SELECT armeId, armTexte > FROM armesArmoriaux > 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? I do not think 2 ms per record is all that much for Access. > 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 driver? There is a reason the docs warn not to use ODBC But you might be trashing memory as well.. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:320254 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
