My .02... Simply put, cffile previous to MX is not the right tool for parsing large text files. MX might not be great depending on if they used any of Java's io buffering. I haven't put cffile in mx through a torture test yet, and I had to reinstall my machine with the preview release on it. If someone out there feels like doing some comparisons, I for one am really curious :) However parsing text is one of the most basic tasks in any language. You might want to take the oppurtunity to hone your Java skills in preparation for the brave new world we are entering...
Check out this UDF for how to use Java's ability to treat a file as a stream allowing you to use CF to parse bite size chunks of the file. It probably isn't that speedy as it sits, but add a buffer and performace would go way up. However if you leave out the part where it concatenates the file into memory and just do your parsing in the loop, it will probably use a lot less memory than cffile alone would require. http://www.cflib.org/udf.cfm?ID=417 On the other hand, using SQL Server would be the easiest way to do this imho. jon ----- Original Message ----- From: "Charles Nahm" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 6:05 PM Subject: RE: Reading only part of a really big text file... > >-----Original Message----- > >From: Jerry Johnson [mailto:[EMAIL PROTECTED]] > >What, may I ask, are you trying to do with it? > > I guess analyze for patterns would be the best description. Basically just > wanted to do text searches for key phrases. > > >If you are trying to garner info out of it, may I suggest grep, > >sed & awk, or perl? Depending on your need for searching. > > Are these Unix tools? We are running Windows 2K. > > >If you need to query it as if it were data, do you have access to > >MSSQL and DTS? You could import the whole darn thing into a table. > > > >If you need to analyze the info in it (look for patterns and > >such), there are a number of free web log analysis tools out there. > > Thanks, I was not aware of this. > > Charles Nahm > Sonic Networks Inc. > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
