I would advocate the usage of Stored Procedures. You can obfuscate the business logic and have a high performing query that has a set execution. You can put them in many palces to make life simple.
Teddy On 2/28/07, Scott Weikert <[EMAIL PROTECTED]> wrote: > > Well, with a small tweak to a couple of the queries I was doing, I > greatly reduced the time involved to run through these bits... so no > more need for going the view route. :D > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2756 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
