Couple days late on this, but... I usually use SQL Server DTS packages to do my heavy file lifting - I set-up a connection to the file and place the contents into the db. If I'm not worried about real time data, I schedule the package. You can also run a dts package through cf using COM. You really don't want to use cffile with what you're doing. I don't know if you're using sql server or if your host will allow you to utilize dts packages (probably not), but it's worth a try.
Mark -----Original Message----- From: B G [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 5:40 PM To: CF-Talk Subject: Querying a text file I am building an application where users can upload a comma delimited text file to a unique user directory then retrieve the data from it for later use. The structure of the file will be pre-defined and the users must follow that format. Field names are included in the first row. I had intentionally decided not to import that data from the text file into a table because of the file size. Reading the contents of a file with CFFILE puts the entire contents into a variable which takes up memory. 100 users all working with 10 meg files at the same time could cause a problem. But I am finding that no host will offer to support a text ODBC connection. I even had one tell me it couldn't be done. Also, a few have stated that querying a text file is too flaky to be considered reliable. Has anyone had any experience similar to this? Am I worrying about using too much RAM unnecessarily? Perhaps a more efficient way to get the contents of the text file other than CFFILE? Thanks! BG _________________________________________________________________ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4