Skip to content

Vettabase

Osserva i tuoi database da una vetta. Lascia a noi i problemi tecnici.

Menu

Menu primario

  • Servizi
    • Database Automation
    • Health Checks
      • MariaDB
      • MySQL
      • Cassandra
      • PostgreSQL
    • Monthly Time
    • Formazione
      • MariaDB
      • MySQL
      • Training per Analisti
    • Upgrades and Migrations
      • Upgrade dei Database
      • Migration from CentOS
  • Articles
    • Vettabase
    • Automation
    • MariaDB
    • MySQL
    • PostgreSQL
  • Carriere
  • Vettabase
    • Testimonianze
    • Rassegna Web
    • 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 inStored Procedures | 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

  • Vettabase is now a MariaDB Foundation Technology Partner
  • Sizing Aria Pagecache
  • How to skip an Ansible task by default
  • Can we shrink InnoDB Buffer Pool?
  • Is InnoDB Buffer Pool big enough?

Categorie

  • Amazon Redshift
  • Database Automation
  • Databases
  • MariaDB
  • MariaDB InnoDB
  • MariaDB Storage Engines
  • MySQL
  • MySQL InnoDB
  • PostgreSQL
  • SQL Language
  • Stored Procedures
  • Systems
  • Vettabase

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 © 2021 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
Policy dei Cookie

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