> -----Original Message----- > From: Dave Watts [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 05, 2003 12:50 PM > To: CF-Talk > Subject: RE: all records deleted from table > > > > BTW, materialized views can be implemented in any > > database that can use triggers. I don't really > > understand why many database vendors insist on > > naming them views when they are just extra tables. > > Because putting "Now, more tables!" into the sales material > just doesn't have the same effect as "Now, with materialized views!"
True - but there is something to be said for abstracting this. You can build them in any DB that offers triggers, sure. But if the DB offrs support for them then you can just "Create index" and be done with it. The DB does all the work, hides all the triggers and tables, and let's you ignore the processes. You can maintain them easier, manage them easier, etc. It may not be a big feature, but come on - it IS a feature. ;^) > Jochem, you're a smart guy, but you'll never make it in marketing. Agree... and agree. ;^) Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
