Dynamic sql vs stored procedures - pros and cons?

Posted by skyeagle on Stack Overflow See other posts from Stack Overflow or by skyeagle
Published on 2010-05-04T23:42:35Z Indexed on 2010/05/04 23:48 UTC
Read the original article Hit count: 210

Filed under:
|
|

I have read many strong views (both for and against) SPs or DS.

I am writing a query engine in C++ (mySQL backend for now, though I may decide to go with a C++ ORM). I cant decide whether to write a SP, or to dynamically creat the SQL and send the query to the db engine.#

Any tips on how to decide?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about sql