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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
