Ben Nadel wrote: > Sorry to come in late in the convo... If you can put the file in a public > directory, I have found from some simple testing that CFHttp is faster than > a buffered file reader... > > http://bennadel.com/blog/200-ColdFusion-CFHttp-To-Query-Much-Faster-Than-Jav > a-Buffered-Reader.htm > > DISCLAIMER: I am a ColdFusion programmer, not a Java programmer, so there > are probably issues.
Hey, that's pretty cool. Your method does work very well provided you're looking at well formatted, query like data (like a quality CSV) and the file is accessible via http. Of course, you can't do *ANY* validation on the data until after the data is loaded into the query... so that could be a disadvantage. but still that's pretty cool. Using CFHTTP to generate a query object was somethingthat I'd never really had a need for before. Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252293 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
