stored procedures

[Richard Pieri]

On Aug 31, 2010, at 10:52 AM, Tom Metro wrote:
> 
> remember, review, test, or debug. Will the performance boost of using a
> domain specific language be worth it? (I'm not a big fan of introducing
> a bunch of limited mini-languages into a project when a well designed
> library API can accomplish much of the same clarity without introducing
> a new syntax.)

IME yes, it does.  High-level APIs are wonderful to fantasize about but when profits are measured in milliseconds you use the fastest tools you can get your hands on.

> I'm surprised that no one in this thread has mentioned web services,
> which is what has largely replaced stored procedures on large systems.
> You get a similar separation of application and storage layers, while
> sticking with your familiar development language and tools.

They haven't.  I could point at two massive databases -- one ~10TB and growing, one ~25TB and growing -- in production, in two high profile companies, where stored procedures are used extensively in the Oracle databases.

--Rich P.