Re: Returning result of a simple "select * " from a stored procedure without using cursor

> If middleware can deliver. Just remember that almost everything you
> can do in a middleware tier, can be done in the database tier.. and
> often better as the db tier is many times more mature and scaleable.
>
> But this is getting way of topic. :-)

Good, and yes. It is a good topic though. I do think client server is dead, and that the world now requires generic thin clients that get all the power the backends have, and now requiring them integrated. I feel that the DBMS is inherently client-server, and should be isolated enough to do what it does best, set-based data processing, not even handling the ad-hoc requests of thousands of online-catalog browsers etc.

   If the DBMS were so good at all things, you wouldn't find that all the benchmarking of DBMSes, even in such a simple DBMS-centric online processing test as TPC-C use an external transaction monitor. Parenthetically, the current TPC-C performance champ is Oracle+BEA. As soon as you have an enterprise-class application requiring messaging, fancy personalized UI and WebServices and single-sign-on integrated security to integrate multiple backend applications, you need a very powerful middle-tier platform. The DBMS is relegated rightly to the crucial but specific backend component it supplies. Regards,
Joe

>
> --
> Billy
Received on Tue Oct 21 2003 - 11:41:53 CDT