my way may not seem the best, knowing that there are many Gurus in this field, but i always take the easiest and simplest routes to achieving my goals.
Write simple queries that will import the data from each CSV. ________________________________ From: Donnie Carvajal <[email protected]> To: cf-talk <[email protected]> Sent: Tue, April 20, 2010 3:41:22 PM Subject: Data Imports I have a question about preferences for importing data and filtering the data through CFCs. We have functionality in our app to upload a csv file to make mass adds/updates. From the file, we are loading the data into a database table. The app has many great CFCs that create beans and DAOs that manage all of the business logic for adding/updating through the GUI of the app. Would you suggest taking each record in the table the data was imported to and creating an object for each record and using the normal add/update logic that the CFCs already handle or would you suggest writing a single UPDATE query and an INSERT with SELECT query to get the data into the system? It seems the greatest reason for using CFCs is to encapsulate all of the business logic in one spot to avoid having to change code in many different places, so creating objects would be the wiser choice; however, some of these imports will have thousands if not tens of thousands of records and CF is very slow at creating objects, so it seems it would be more beneficial to simply write queries to translate the data and duplicate the logic. Thoughts? Thanks, Donnie ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333038 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
