Databases Archives - Lance Cleveland

Related Meta Table For Efficient Data Architecture

June 2, 2023June 2, 2023Lance Cleveland

Over the course of more than two decades as a software engineer, architect, system lead, and CTO I’ve worked on dozens of data-driven software applications. I’ve help build some of…Continue readingRelated Meta Table For Efficient Data Architecture

Aurora MySQL Storage Monitoring & Reduction

August 4, 2022Lance Cleveland

Using Aurora MySQL is a great way to host a MySQL database at low cost while providing a scalable and fault tolerant environment. Once you’ve setup your multi-zone cluster AWS…Continue readingAurora MySQL Storage Monitoring & Reduction

Databases PHP Technology WordPress

WordPress 4.8.2 Data Query Woes

September 21, 2017Lance Cleveland

Millions of websites across the Internet were automatically updated to WordPress 4.8.2 yesterday. Thousands of those sites have key components that are no longer working. Many of those…Continue readingWordPress 4.8.2 Data Query Woes

Databases Technology

Performance Benefits Of COUNT(*) In SQL

November 5, 2016Lance Cleveland

This is something I often come across in code. Just came across it in our MySLP project today , in fact. SELECT count(id) FROM my_table While the performance impact of…Continue readingPerformance Benefits Of COUNT(*) In SQL

Databases Development

Performance Issues? Check Your Indexes

April 7, 2016February 6, 2023Lance Cleveland

Any of the tech geeks that have worked for me in the past have heard me say it a million times. “Check your indexes , people!” It is the single-most…Continue readingPerformance Issues? Check Your Indexes