Subject Re: Design advice
Author jgeer2002
--- In, "jgeer2002" <jagonzalvo@h...>
> I'm developing a commercial application that uses Firebird. At the
> moment I have all my queries coded in stored procedures.
> The process to deploy updates to my app I think is going to be
> painful, because for example, in order to modify a field I have to
> delete every stored procedure that reference that field, make the
> modifications and recreate the stored procedures.
> I'm thinking of dropping all my stored procedures and use dynamic sql
> directly from my code instead.
> I would like to know your opinion about this. What drawbacks can I
> expected?

Ups, seems that in this thread
covers a similar topic. Anyway, the second part of my post is still
valid. Are there performance issues by using dynamic sql?