Maaz Zindani

Loading the index…

↑↓ move↵ openesc close4072 pages

Monthly plan

A slow database measured, fixed and kept fast, month by month

In the database performance plan I find why your MySQL, MariaDB or PostgreSQL database is slow and fix it month by month: I read the slow queries, add or change indexes, tidy the schema and use Redis where it helps, measuring before and after each change. The price is quoted after a short discovery call, against a written scope.

Who is Database Performance Plan for?

  • Owners of an app or portal that slowed down as the data grew.
  • Teams whose reports, searches or lists take far too long to load.
  • Companies whose original developer left and nobody has looked at the queries since.

What does Database Performance Plan include?

  • A written review firstI measure the slowest requests and queries on the live system and tell you in writing what costs the most time.
  • Slow query diagnosisI look at what each slow query actually does, rather than guessing, and fix the worst ones first.
  • Indexes and query changesIndexes are added or removed and queries rewritten one at a time, with a measurement after each to prove it helped.
  • Schema and migrationsWhere the data model is the problem, I propose changes and run migrations carefully, with a backup beforehand.
  • Caching with RedisWhere repeated reads are the cost, Redis caching is added with a clear rule for when cached data expires.
  • Application side fixesMany slow screens come from an API asking the database too much, so I fix the code that asks as well as the database.
  • Backups and safe changesA backup before any production database change and a way back for each one.
  • Written updates, one weekly callA short written update with the before and after numbers, plus one fixed overlap call each week.

What does Database Performance Plan not include?

  • A promise of a specific speed-up. The numbers depend on what I find.
  • Database types outside MySQL, MariaDB, PostgreSQL and Redis.
  • A full-time database administrator. I am one engineer.
  • Work without a written scope. Every month runs against one.

How does Database Performance Plan work?

  1. Send me a few linesWhich database, what is slow and since when. I reply within 24 hours.
  2. A discovery callA call within 48 hours to understand the product and how the data is used.
  3. A written review and scopeThe measured slow spots and a scope for the first month.
  4. KickoffTypically inside two weeks, with a backup and read access set up before I change anything.
  5. Month by monthOne change at a time, measured the same way before and after, with written updates.

Is Database Performance Plan a good fit for me?

A good fit when

  • Your app was fast once and is not any more.
  • You see timeouts or heavy server load that point at the database.
  • You want proof of what changed, not a vague promise that it is faster.

Not a fit when

  • Your database is fine and the slowness is on the user's phone or network.
  • You need a data warehouse or a full analytics platform.
  • You want a one-off fix and nothing after.

What do people ask about Database Performance Plan?

What does database tuning cost?

It depends on the size of the system and how much needs fixing, so I quote a monthly figure after a short discovery call, against a written scope.

Which databases do you work with?

MariaDB, MySQL and PostgreSQL, with Redis for caching.

How will I know it worked?

I measure the same requests the same way before and after each change. If the number did not move, the fix did not work.

Will you change my data?

Only with a backup taken first and a way back, and only changes that the scope covers.

Related projects

All projects

Own product · Taxi dispatch SaaS

TaxiDex

My own multi-tenant taxi dispatch SaaS: API, dispatcher portal, driver and passenger apps, and the servers underneath.

TypeScriptNode.jsAdonisJSNext.js

Live SaaS · Android systems

QistLock

A NestJS and React SaaS driving an Android Device Owner agent that locks financed phones when payments lapse.

NestJSTypeScriptTypeORMMySQL

Logistics and ride dispatch

Dispatch Pro

A real-time logistics platform: Flutter apps, Spring Boot services and a Kafka event pipeline on AWS.

FlutterKotlinSpring BootWebFlux

Next step

Database Performance Plan: let's talk

A discovery call within 48 hours, and a kickoff typically inside two weeks.