I think I'd have to disagree since he said the max size is about 1MB. Looping over a 1MB text file where all you're doing is looking at the first letter of an item in the list shouldn't be be slow at all. In fact I'd think it would be done in the time it took you to mess around creating DSN connections etc. Plus I always prefer programmatic vs. manual.
This does pique my curiosity though. Ian, any chance you could post an example of your largest text file so I/we could do some testing? On Wed, Apr 22, 2009 at 2:20 PM, Robert Munn <[email protected]> wrote: > > I like this solution. Parsing large text files is going to be slow in CF > relative to using a flat file ODBC driver. > > Check this out, should be easy on a Windows machine... > > http://www.herongyang.com/jdbc/JDBC-ODBC-Flat-Text-File.html > > > > > > On Wed, Apr 22, 2009 at 7:44 AM, Jerry Johnson <[email protected]> wrote: > > > > > programmatically hook them up in coldfusion as datasources, and search > > the column? > > > > > > > > On Wed, Apr 22, 2009 at 10:15 AM, Ian Skinner <[email protected]> wrote: > > > > > > You have a several dozen text files ranging in size from ~1KB to ~1MB > > > each. These files are column delimited data files and you need to find > > > records in any of the files that have an 'F' character at column 26. > > > You have normal tools available on a Windows XP Pro computer and > > > ColdFusion developer. How would you go about this quickly and > > efficiently? > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:295657 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
