I will optimize slow mariadb queries for dashboards and reports
About this Gig
Does your dashboard load quickly for one day of data but time out when you select a full month? Ill investigate the slow MariaDB query behind your report and show you where it spends its time.
Ill review the SQL, table structure, and indexes, then use the query execution plan to identify unnecessary scans, joins, or sorting. Youll receive a written diagnosis explaining what I found, which change I recommend, and why it fits your report.
If your order includes optimization, Ill test the revised query or index on a staging database or representative dataset. Ill compare execution times using the same filters and check that the original and revised queries return matching results, including row counts and report totals. Youll receive the SQL changes, test results, and instructions for applying the update.
To get started, send your MariaDB version, the affected query, its usual runtime, and an example date range or filter that triggers the slowdown. An anonymized example is welcome.
Platform:
MariaDB
Expertise:
Design
•
SQL
•
Performance
•
Query optimization
