Tell about reducing database load by 30% — what was done?

To reduce the load on the database by 30%, the following measures were implemented:

1. Caching frequently requested data — Redis was introduced to store the results of common queries, which decreased the number of database calls.
2. SQL query optimization — rewritten heavy queries, added necessary indexes, removed redundant JOINs.
3. Pagination and limiting the result set — for large tables, a limit was added to the number of returned rows.
4. Asynchronous processing — some operations that do not require immediate results were moved to a processing queue.

As a result, thanks to these changes, the load on the database decreased by approximately 30%, which improved the overall system performance.