--- In firebird-support@yahoogroups.com, "jgeer2002" <jagonzalvo@h...>
wrote:

> 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
(http://groups.yahoo.com/group/firebird-support/message/65260?threaded=1)
covers a similar topic. Anyway, the second part of my post is still
valid. Are there performance issues by using dynamic sql?