I will optimize slow sql and clickhouse queries
Dotnet and Blazor Developer for Fast APIs and ClickHouse
About this Gig
Are your reports, dashboards or APIs slowed down by heavy queries?
I work daily with ClickHouse, SQL Server and other databases behind a high-traffic platform that stores millions of events a day. I find out why a query is slow and fix it, without changing your results.
What I can do:
- Rewrite slow SQL and ClickHouse queries
- Add or fix indexes, partitions and sort keys
- Design materialized views and pre-aggregated tables for fast reports
- Review your schema and fix data types and table design
- Spot duplicate rows, wrong joins and timezone mistakes in reports
What you get:
- Optimized query or schema scripts, ready to run
- Before/after timings so you see the improvement
- A plain-English explanation of what changed and why
Send me the slow query and a sample of the data, and I'll tell you what I can fix before you order.
Platform:
PostgreSQL
•
SQL Server
•
Other
Expertise:
Data warehouse
•
Performance
•
Query optimization
FAQ
Do you need access to my production database?
No. The slow query, the table definitions and the query plan or timings are usually enough. Read-only access to a copy or test database helps for bigger jobs.
Which databases do you work with?
Mainly ClickHouse, SQL Server and PostgreSQL. I also work with ScyllaDB/Cassandra-style data models. Ask me if yours is not listed.
