How do I open large Textfiles!

[Maetu]

Hi everybody!

I'm opening a textfile and reading from it with the following lines:

<CFFILE ACTION=&quot;READ&quot; FILE=&quot;File&quot; VARIABLE=&quot;List&quot;>

<CFLOOP INDEX=&quot;fLine&quot; LIST=&quot;#List#&quot; DELIMITERS=&quot;#CHR(13)# #CHR(10)#&quot;>

As long my file will not overstep 2 MB everything works fine.... If they are larger the server will be overloaded....

Now: How can I read a file over 2 MB? Can I read it sequential?

Note: The Server has 1GB of Memory, so I don't understand why he can't handle this!

Thanks 4 your help

Mätu

 

[csteinhilber]

Have you tried using a text DSN?

Don't know if it'd be any better at handling text files that size... but it'd be worth a shot. I dunno... I've never had a text file that was that large ;-)


-Carl

 

[flowcontrol]

If you are using CF MX, try CFBufferedReader, which you can find at macromedia.com (go to the DevNet and search for it). It's a great example of how to use Java in ColdFusion.

Another thing to try is a user-contributed CFX tag called FileReadLines. This tag allows you to read any number of lines (or even a single line) at a time. There are probably other CFX tags that do something similar. It used to be on Allaire's website, but I couldn't find it on macromedia.com. If you want to try it, I can send it to you (it's freeware).