Stored Procedures... are retarded

[Lance Olinger]

Seriously? Who came up with this?
There's an extremely simple alternative... you have a table with sql queries..
you join the table with whatever your qualification criteria is... you evaluate the field with sql code as a query instead of text with a function... done.

Calc_Type Formula
1 a*b
2 a/b

SELECT count*EVAL(formula) FROM table1 INNER JOIN calculation ON table1.calc_type = calculation.calc_type

End result is a single mysql query that can perform multiple calculations WITHOUT stored procedures. IMPLEMENT IT!

Instead with stored procedures you've got to basically write out a whole coding language to build and execute the query... that's what coding languages are for! It's quicker and easier to build the query with whatever coding language you are working in than it is to build it using stored procedures.



Edited 2 time(s). Last edit at 01/20/2012 11:35AM by Lance Olinger.