It is necessary to optimize the database.

Budget: 7500 UAH Deadline: 5 days

Slow queries are usually addressed not by "speeding up" the database, but by finding bottlenecks: EXPLAIN, slow log, indexes, rewriting heavy JOINs. On shared hosting, it's important to stay within limits — first, I will gather metrics and query plans, then I will make changes. Steps: 1) diagnosis — slow query log, EXPLAIN for problematic queries, structure and size of tables; 2) eliminating causes: missing indexes, N+1, unnecessary selections, incorrect field types; 3) rewriting queries and targeted caching of frequent selections; 4) re-measuring load and recording results. I work with PostgreSQL/MySQL, have experience synchronizing large volumes of data via API and preparing them for CMS — https://freelancehunt.com/showcase/work/razrabotka-parsera-sistemyi-avtomatizatsii-allegro/2039438.html Will you provide access to the database and hosting (or a dump + examples of problematic queries)? Which sections/functions are currently the most sluggish?

Price: 7500 UAH
Term: 5 days

Budget: 6000 UAH Deadline: 7 days

Hello, I recently conducted a similar audit of a database for slow queries: analyzing EXPLAIN for heavy SELECTs, adding the correct indexes, rewriting queries without unnecessary JOINs and subqueries, configuring MySQL for the hosting resources. Optimization specifically on the shared hosting ukraine.com.ua was also part of that project, as there are specific memory limits.

If you have many identical queries for each page request, it's worth adding result caching right away, as this usually reduces the load on the database by about 30-40%.

How many tables are approximately in the database and which specific pages or queries are causing the most slowdown? Is this a one-time optimization or will ongoing monitoring be needed?

I suggest we get in touch, and I will also draft an audit scheme with a list of slow queries for your database, so you can see it live.

Budget: 3500 UAH Deadline: 3 days

Good day, I have over 5 years of experience in development, often optimizing databases and SQL queries for fast project performance.

I will optimize the database structure, review the queries, and speed up data retrieval. I will identify bottlenecks or inefficient indexes.

I have attached an example of my work. Please take a look.

I am available to start in 3-5 days, depending on the volume of data and the number of queries. I will provide the exact cost after a few clarifications or in private messages.

What is the size of the database (number of tables, records) and are there any particularly critical slow queries to start with?

Feel free to reach out! Expand

Budget: 2000 UAH Deadline: 3 days

Good day, Oleksandr.

I work with PostgreSQL and MySQL, and query optimization is a regular part of my job.

Action plan:
1. I enable the slow query log and collect real slow queries over a day — we need to optimize what is problematic, not just what looks suspicious.
2. EXPLAIN ANALYZE on the top: seq scan where there should be an index scan, unnecessary JOINs, N+1.
3. Indexes for specific queries, rewriting the heaviest ones, and if necessary — denormalization or caching.
4. Measurements before and after, so the results are in numbers, not just words.

Please clarify:
— MySQL or PostgreSQL?
— Approximate size of the database and how long the slowest query is currently taking?
— Is there access to the DBMS configuration? On the shared hosting ukraine.com.ua, some parameters are restricted — in that case, we will work at the query and index level.

I will start with an audit: I will look at the logs and provide a list of issues with an estimate of how much each fix will yield. Then you can decide what to do. Expand

Budget: 1900 UAH Deadline: 3 days

Deadline - 3 days. Budget - 1900 UAH for audit, indexes, and rewriting heavy queries.

Alexander, I consistently work with MySQL optimization on shared hosting and know well where ukraine.com.ua starts to "choke" the database. On this hosting, key_buffer_size and buffer_pool are strictly limited, so classic advice like "just increase buffers" doesn't work here. We need to break down the query itself.

From the screenshot, I see that there is a feed from some aggregator or network of sites pulling data from several tables at once. If this is a CMS with a blog and records through a dozen JOINs, then without proper composite indexes, the database performs filesort even on a small volume. I will rewrite the problematic queries and set composite indexes based on real WHERE patterns.

The main thing: before any changes, I will make a full dump and run it on a copy. On shared hosting, rolling back through backup is the only reliable insurance.

Do the queries drop evenly across the entire site or is it a specific page or bot that is slowing down?

Budget: 2000 UAH Deadline: 3 days

Ready to quickly resolve the issue with slow queries and optimize the database. Well acquainted with the specifics of the hosting ukraine.com.ua and their control panel. First, I will export the slow query log, identify all the "heavy" queries, add the necessary indexes to the problematic tables, and clean the database of outdated temporary data. I will also rewrite the SQL queries in the code to prevent them from overloading the server when visiting pages. Before starting the work, I will definitely make a full backup of the database.

Budget: 2000 UAH Deadline: 3 days

Hello, Alexander.

I am ready to conduct diagnostics and optimization of the database and queries.

First, I will determine where exactly the delay occurs: in the database structure, absence or incorrect use of indexes, individual SQL queries, large volumes of processed data, or hosting limitations.

As part of the work:

1. I will check the database structure and the most loaded tables.

2. I will find slow queries from logs or directly in the project code.

3. I will analyze queries using EXPLAIN and determine where a full table scan occurs or where indexes are not used.

4. I will add or adjust the necessary indexes.

5. I will optimize heavy JOINs, subqueries, sorting, and data retrieval.

6. I will check the execution speed of queries before and after changes.

7. Before making changes, I will create a backup of the database or provide a list of necessary actions for its creation.

The preliminary cost is 2,000 UAH, with a timeframe of up to 3 days.

I will be able to confirm the exact volume estimate after receiving information about the DBMS, CMS or framework, the size of the database, and examples of pages or operations that are currently slow.

If the problem is limited to a few queries and indexes, the work will fall within the specified cost. If significant code or database architecture rework is required, I will first provide a separate estimate and agree on it with you. Expand

Budget: 1500 UAH Deadline: 3 days

Hello! Do you use indexing for fields that frequently appear in WHERE and JOIN?
We can discuss exact terms and budget in more detail in a private message.

1. I will analyze slow queries through logs and EXPLAIN to find bottlenecks.
2. I will optimize the table structure: add indexes, review data types, and normalization.
3. I will rewrite heavy queries, eliminate unnecessary subqueries, and optimize JOINs, considering hosting limitations.

Thank you for considering my proposal. I am excited about the opportunity to work with you!

Budget: 2000 UAH Deadline: 3 days

Hello, Alexander! Slow queries on the Ukraine hosting are hitting the CPU/RAM limits. It's important to set up indexes and optimize heavy JOINs, rather than just clearing the cache. I have solved such problems with MySQL/PostgreSQL multiple times.

What database management system do you have, and which CMS or framework is the site running on?

I am ready to create an optimization plan after analyzing the slow queries.

Budget: 2000 UAH Deadline: 3 days

Alexandra, I understand that the slow performance of the site due to inefficient queries directly affects user experience and the load on hosting. To address this, I will first analyze the execution plans of the queries and identify those that require indexing or refactoring. In addition to the queries themselves, I will check the table settings to ensure stable page loading speeds on ukraine.com.ua. Do you have a slow query log on the hosting so we can immediately see the most critical areas?