Database - Pixelite

Drupal

Search API attachments and storing reasonable amounts of data

Search API Attachments has a setting that allows you to store only the most important information in the database.

Drupal

Deleting multiple fields with large amounts of data in Drupal 7

Sometimes truncation is best

Drupal

Measuring Drupal content growth over time

A graphical way to see how your Drupal site content is growing over time

Drupal

Using EntityCache to speed up your Drupal site

Make your Drupal 7 sites faster

Drupal

Convert an existing textfield into a textarea in Drupal 7

SQL to the rescue

Drupal

How to speed up Drupal by altering the tokens UI

On larger Drupal sites, the Token module quickly becomes unwieldy, and the UI can consume precious resources while often being never used. Here are some options for mitigation of this.