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
