On Thu, May 22, 2014 at 1:33 AM, Lafras Henning [email protected][firebird-support] <[email protected]> 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
