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:333032 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
