On Thu, May 22, 2014 at 1:33 AM, Lafras Henning lafras@... [firebird-support] <firebird-support@yahoogroups.com> wrote:

 

Hi Steve,

Do you think the performance gains were mostly due to the elimination of
the sub procedure, or mostly due the pure speed of the C functions?

During testing did you ever run the UDF still from within the SP and if
so how was the performance increase?

In other words did the fact that it was a stored procedure vs in line
queries have a significant impact?

Regards

Lafras

Hello Lafras,

Unfortunately we did not do any direct comparisons, we had a fairly large job that called many different stored procedures and also fired off some complicated trigger logic.  When we replaced the string calculation function with the C based UDF we saw a big performance increase.  This was several years ago though (probably 6-7 years) and I am having some trouble remembering the details...  Just wanted to weigh in with what we saw here.

Thanks,

Steve