Well, I may be wrong, but one of the advantages of N-Tier development is that you can switch out the Data/Rules/Interface in a mix and match mode. My app can take advantage of several backends without alteration??



Bob

>>Hi Kevin
>>What if you want to switch the data to point to say Oracle or MySql?
>>
>>Bob
>>
>
>Stored Procedures take advantage of one of the fundamental advantages of a server-based database - data is processed on the server using the server's memory and only results sets are returned to the client saving network resources. This is a big deal on busy LANs, and a huge deal for web apps and web services.
>
>Plan appropriately first so you don't have to switch to completely different data providors. Oracle and Microsoft SQL servers scale from workstation to enterprise seamlessly so there's no real compelling reason to switch. If planning was bad initially or a company just wants to spend lots of extra money, then they can go ahead and switch.