Skip to content
  • +44 7739 427279
  • info@federico-razzoli.com

Federico Razzoli

  • About Me
  • Newsletter
  • Webinars
  • Vettabase
  • Contacts

Month: June 2019

How to return random rows from a table

Federico Razzoli June 25, 2019December 8, 2019 3 Comments

Returning random rows in a random order from a relational database is a very hard problem. In this article we will see an antipattern, we will discuss why this problem is so hard, and we’ll examine some imperfect solutions.

Read more
Query optimisation

Paginating the results of an SQL query

Federico Razzoli June 21, 2019December 17, 2019 6 Comments

One of the trickiest problems in SQL is to query rows in tranches. This is typically needed in a website search, or in a dynamic catalogue where products appear as you scroll down. You want the DBMS to only return …

Read more
Query optimisation

London Open Source Databases meetups in July 2019

Federico Razzoli June 17, 2019December 10, 2019 Leave a comment

In July, London Open Source Databases group will see a meetup with Peter Zaitsev and one with Monty Widenius.

Read more
Community and news

MySQL stored procedures: all ways to produce an output

Federico Razzoli June 6, 2019February 8, 2020 4 Comments

There are many non-obvious ways to return values from MySQL stored procedures, and each of them solves particular problems.

Read more
Stored procedures

Dropping useless MySQL indexes

Federico Razzoli June 4, 2019April 1, 2020 6 Comments

How to find useless indexes and get rid of them to improve your database performance.

Read more
Operations

Recent Articles

  • Do languages need NULL? – Rust example
  • Webinar: Database Design most common pitfalls
  • Consistency Level patterns for high accuracy in Cassandra
  • MySQL backup methods comparison
  • Sizing Aria Pagecache (→Vettabase)
  • Webinar: MySQL Backups
  • Can we shrink InnoDB Buffer Pool? (→Vettabase)
  • Is InnoDB Buffer Pool big enough? (→Vettabase)
  • About Planet MySQL
  • MySQL danger: comments and ALTER TABLE

Categories

  • Amazon Redshift
  • Cassandra
  • Community and news
  • InnoDB
  • Monitoring
  • MySQL and MariaDB
  • MySQL for devs
  • Operations
  • PostgreSQL
  • Query optimisation
  • SQL
  • Stored procedures

Recent Comments

  • Federico Razzoli on Working with JSON arrays in MySQL/MariaDB
  • Daniel R. on Working with JSON arrays in MySQL/MariaDB
  • Federico Razzoli on Working with JSON arrays in MySQL/MariaDB

Archives

  • June 2020 (4)
  • May 2020 (3)
  • April 2020 (4)
  • March 2020 (3)
  • February 2020 (2)
  • January 2020 (3)
  • December 2019 (2)
  • November 2019 (1)
  • October 2019 (2)
  • September 2019 (3)
  • August 2019 (3)
  • July 2019 (1)
  • June 2019 (5)
  • May 2019 (6)
  • April 2019 (7)
  • March 2019 (4)
  • February 2019 (6)
Copyright © 2021 Federico Razzoli.
Powered by WordPress. | Theme: colorskin by Dimitrakopoulos.