UDF is a User Defined Functions in InterBase. They are similar to stored procedures. The difference is that instead of writing stuff in SQL and execute it in the database, we are loading functionality from DLLs.
In this CodeRage session, you will learn how to create User Defined Functions in InterBase.
Why you should use UDFs?
- Can perform functions that are not normally available in SQL language
- Allows you to extend the architecture of the server
- Can perform routine tasks
- Can perform complex functions that are too hard in SQL
- UDFs should reduce the bandwidth and distribute the applications load
UDFs are excellent if you have problems in terms of whatever processing strings in your queries than that’s an excellent technique to improve or add your algorithms. But, it should be on the non-business side of your code.
If you would like to learn more about the User Defined Functions and see the results in an action, be sure to watch the session!