>>* Rollbacks of failed data transactions won't leave orphaned binary files.
You have to store the file on disk anyway when it is uploaded. If you also store the file content in the database, FIRST you have to copy the file from its temporary location to the database, which is an extra overhead for the server, SECOND, you have to delete the file from its temporary location anyway, whether the transaction succeeds or not. >>* May simplify migrating a system to a different data store location. May be, but the purpose of a database is to make data manipulation efficient, not to be migrated. This reminds me the "big advantage" of the Pascal language when it came out (one the first formal language) They said " This language makes writing compilers for it much easier". Big deal, the purpose of a language is to make programming easier using it, not to write compilers for it. -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301814 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
