Changing the method you use to extract the data has no impact on traffic, unless he means traffic between the ColdFusion server and the Database server.
Depending on the size of the file, you will get much better performance from a relational database than you will iterating over a sequential file. Opening and reading a file, then looping over all the rows to determine which ones are active is going to take much more time than a simple database select. Also, you can improve the performance in the query by only selecting the two fields you are using instead of doing a Select * On Fri, Sep 7, 2012 at 5:42 AM, Steve LaBadie <slaba...@po-box.esu.edu>wrote: > > The traffic has reduced a lot but my System Admin is request that I use > a Flat File to reduce traffic even more. Never used a flat file before > or how CF would handle it. Any guidance would be appreciated. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352449 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
