Subject RE: [firebird-support] UDF registration
Author Alan McDonald
> Hello,
>
> I executed these sql scripts to register UDF librarys
> fbudf.sql
> ib_udf.sql
> and was expecting to work these udf for all databases, but when I
> created new database these UDF were not working. Should I register
> UDF for each database or there are other way to make firebird work
> with UDF without registering each time when I create DB?
>
> Should I register just these UDF that I use in my querys?
> If I register all functions that are in fbudf.sql ib_udf.sql, will
> it make no impact for performace?

registering a UDF library with each and every new database you create is
much like creating the tables and views each time. Yes they are
database-wide , not server-wide.
There will be no impac on performance by just registering them. But they
will take up alittle more space in each database.
Alan