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 <[email protected]> wrote: > > On Wed, Apr 22, 2009 at 12:04 PM, Michael Grant <[email protected]> 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:295682 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
