Hi All.

I'm trying to load an extremely load file via CFFILE.  This file is the RDF 
content file from the Open Directory Project.

I've already built the script which imports the file, loads into a set of 
structures, and then strips out the URLs and inserts into a database.  This 
script has been tested with a subset of the entire RDF file.

However, when I try to run this script with the entire file (approximately 
820Megs in size), I get a memory error.  I've resorted to splitting the 
file into smaller segments, but each file is taking a huge amount of time 
to load (I've resorted to splitting the file into 10Meg segments).

Can others give me an idea of how they have managed extremely large files 
that need to be loaded into a database via CFFILE?  The file format is too 
complex to simply write a SQL import script.

Thanks.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.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

Reply via email to