Skip to content

Vettabase

Expert consulting and automation for your database infrastructure

Menu

Menu primario

  • Servizi
    • Monthly Time
    • Database Training
      • MariaDB
      • MySQL
      • Data Analysts Training
    • Health Checks
      • MariaDB
      • MySQL
      • PostgreSQL
      • Cassandra
    • Database Automation
    • Upgrade dei Database
  • Blog
    • Database Automation
    • MariaDB
    • MySQL
    • PostgreSQL
    • Cassandra
  • Resources
    • Ebooks
    • VettaArchive
  • Vettabase
    • Company updates
    • Testimonianze
    • Partners
    • Rassegna Web
    • Carriere
    • Contatti

Archivio di categoria: Stored Procedures


Stored Procedures and Triggers allow to implement business logic into the database. While this has many drawbacks, it can also be very useful for many reasons:

  • Validity rules and basic behaviour can be considered as part of the data definition, just like the column names and their types. Having the whole definition in the same place makes the definition cleaner and more maintainable.
  • Processing big amounts of data to produce a small result is often better done in a stored procedure. This avoids data round trip, which consumes resources in both the client and the server, as well as the network itself.
  • Grouping sequences of queries in a procedure allows to reduce client-server communication and data round trip. Typically it also allows to write less code.
  • During a transaction, locks are typically held. If this is done in a stored procedure, locks are held for a shorter time.
  • If several applications read and write the same data, they should implement the same logic, possibly in different languages. This increases the development costs and the amount of bugs. Rules can be implemented once in the database instead.
  • Porting applications from one language to another is much more frequent than migrating from one database type to another. Stored procedures have a longer life than typical applications.

Updating triggers in production with MariaDB and MySQL

Pubblicato il 8 Agosto 2020 da Federico Razzoli — Nessun commento ↓
Landslide danger road sign

Updating triggers in production without causing a service disruption Continua a leggere Updating triggers in production with MariaDB and MySQL→

Pubblicato in Stored Procedures | Taggato mariadb-10.6 | Lascia un commento

Primary Sidebar Widget Area

it_IT Italian
it_IT Italian en_GB English
Vettabase Ltd logo

Content License

Creative Commons License
Except where otherwise noted, the content on this site is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Articoli recenti

  • Deploying an Ansible role on a Vagrant machine
  • A summary of MariaDB 10.8: key performance improvements
  • 3.6 millions MySQL servers accessible from the web. Hints to keep yours secure
  • Tuning PostgreSQL Auto-vacuum
  • How to fix git mistakes

Categorie

  • Amazon Redshift
  • Cassandra
  • Company updates
  • Database Automation
  • Databases
  • MariaDB
  • MariaDB Features
  • MariaDB InnoDB
  • MariaDB Storage Engines
  • MySQL
  • MySQL InnoDB
  • Other Databases
  • PostgreSQL
  • SQL Language
  • Stored Procedures
  • Strategy
  • Systems

Servizi

Scopri come Vettabase può massimizzare l'efficienza e l'affidabilitá dei tuoi database!

  • Health Checks
  • Monthly Time
  • Formazione
  • Facebook
  • Twitter
  • Linkedin
  • RSS Feed
  • Instagram
  • Email
Copyright © 2022 Vettabase. All Rights Reserved.
Theme: Catch Box by Catch Themes
Scroll Up
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking "Accept", you consent to the use of ALL the cookies.
Cookie settingsACCEPT
Cookie Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Sempre attivato
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
ACCETTA E SALVA