Folgende Punkte sind eine "Warum solch ich serverseitige Sachen (Procedures/Trigger) verwenden" Liste aus meinen Vorträgen:
- Run code on any Firebird platform unchanged
- Make the same code for different connectivity technologies available
- Reduce network traffic
- Centralize business logic
- Improve
query execution, because pre-compiled server-side code is stored in the database system tables
- Data abstraction layer
- Ensure customized data integrity
- Enforce business rules
- Build a server-side logging/auditing mechanism
- Notify client applications upon certain events
- Data model checking routines
- Create complex calculation routines
- Create your own functions without using an UDF
- The procedural language PSQL is easy to learn, easy to use and powerful
Wird sicherlich nicht vollständig sein ...
