From: Martijn Tonies
Date: January 6 2004 8:04pm
Subject: Re: Bet the Business
List-Archive: http://lists.mysql.com/mysql/157002
Message-Id: <003e01c3d490$4e6f6c10$0e02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="ISO-8859-15"
Content-Transfer-Encoding: 7bit

All IMHO of course...

> > Will I use them in MySQL 5.0? Probably, but only when justified.
> > </soapbox>
> >
>
> So what are the justifications? What makes a wise stored procedure and an
> unwise stored procedure?

I've used them a lot with Oracle. The n-tier days weren't really alive
when I was doing that project.

We had several reasons to use Stored Procedures:

1) the same set of complicated processing to be called
  by multiple applications and updating that particular piece
  of code without having to update the (client) apps

2) dragging a lot of data across the network was slow.
  With a stored procedure, the processing was A LOT
  faster.

3) without a middle tier: having to use a particular piece
  of code in different programming languages

4) Oracle Jobs require a single statement or procedure
  to run.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com