Let SQL Do All the Work: User Defined Functions

2 years ago thenewstack.io

Summary: This is a summary of an article originally published by The New Stack. Read the full original article here →

SQL user-defined functions are one way to optimize application performance, namely by moving operations from the application layer to the database layer. When working with SQL databases, user-defined functions (UDF) is the “do less” option.

SQL UDFs are functions created to execute in a SQL database that can limit the amount of work going on between layers and optimize the application layer.

Here’s where the optimization kicks in. UDFs remove business logic from the application layer to the database which can optimize the application layer, “do less”, but still perform necessary operations.

They aren’t only used to optimize the application layer but the database layer as well.

DevOps Articles