IMHO, using an application server on a single user to parse text files is in no way quick or efficient. There are much better tools available to do this.
On Apr 22, 2009, at 2:48 PM, Michael Grant wrote: > > I'm still going to disagree based on what Ian's details were: > > - Single user system. > - Scaled to "several dozens of files" > - 1K to 1MB ( I used a 20x larger file for my test so it's probably > closer > to 1 second to do a 1MB file) > - Quick and efficient. > > check, check, check and check. > > Given, if you were looking at scanning hundreds or thousands of > these files > repeatedly then perhaps DSN is the way. But for this solution I > think it's > just too bulky and way more work than is neccessary. It would take > longer to > set up a single DSN than to scan two dozen 1MB files. That's just > sillyness. > > On Wed, Apr 22, 2009 at 3:33 PM, Robert Munn <cfmuns...@gmail.com> > wrote: > >> >> On Wed, Apr 22, 2009 at 12:04 PM, Michael Grant <mgr...@modus.bz> >> wrote: >> >>> >>> >>> So 12.6 seconds to loop over a 20MB text file certainly doesn't >>> "choke a >> cf >>> server." I _highly_ doubt you could even set up the dsn in that >>> amount of >>> time. >>> >> >> If this is a one-time thing on a single-user system, your solution >> is fine, >> but it isn't going to scale. If Ian needs to perform the operation >> more >> than >> once, he's better off setting up a DSN and running a query. >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-community/message.cfm/messageid:295695 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5