MySQL has a capability that allows a knowledgeable user achieve performance speedups while simplifying application logic. A user-defined function (UDF) can be written in C++ thus permitting optimizations on a very low level. UDFs are especially powerful when used to performing complex string manipulations, mathematical logic, and in complex computations that need to maintain a state while examining each row. We will provide some examples of UDFs, explain how they work and how to deploy them, and compare them with benchmarks against more commonly used solutions. [42]


Comments are closed.