I will design mysql database schemas and optimize slow sql queries

5.0
5.0

Pakistan

I speak Urdu, English

27 orders completed

PHP and CodeIgniter Developer for CRMs and Admin Dashboards

I build custom CRMs and admin dashboards, and fix existing PHP and CodeIgniter applications. I have 10+ years of development experience and work with PHP, CodeIgniter 3 and 4, MySQL, Bootstrap, and jQ...

Level 2

Has met high performance criteria and has a proven track record for meeting client expectations.

About this Gig

Need a MySQL database schema with an ERD, or help fixing a slow SQL query? I design and optimize MySQL and MariaDB databases for PHP applications, CRMs, and admin dashboards.


MySQL Query Fix covers one existing query involving up to three tables. I review the query and its execution plan, apply the agreed fix, and summarize what changed.


MySQL Schema and ERD covers up to 10 tables. Database Architecture covers up to 20 tables and adds index design and agreed performance tuning. Both design tiers include a SQL schema script and an entity relationship diagram showing tables, keys, and relationships.


For a query fix, send the query, relevant table definitions, and the error or performance symptom. For a new schema, share your workflow and what the application needs to store. Message me before ordering if you need broader tuning, data migration, or deployment.

Database type:

Centralized database

•

Distributed database

Platform:

MariaDB

•

MySQL

Expertise:

Design

•

ERD

•

Performance

•

Query optimization

My Portfolio

Reviews

4 reviews for this Gig
5.0

(4)
(0)
(0)
(0)
(0)
Rating Breakdown
  • Seller communication level
    5
  • Quality of delivery
    5
  • Value of delivery
    5
Sort By
Most relevant
  • D
    image-docs

    digitalpomegran

    US

    United States

    5

    FANTASTIC! Thanks, Muhammad for helping. He has insights into mySQL and was open to the different ways we use MySQL.

    $50

    Price

    1 day

    Duration

    Helpful?
    Yes
    No
  • C

    contractor_requ

    GB

    United Kingdom

    Ongoing collaboration
    5

    A fast and excellent approach to understanding a problem which had happened, data security, and decrypting data to present well and easy to understand data reports. Also gave good insight into how a problem had arisen and sent previews of work all the way through to ensure we were inline. Highly Recommend!

    $50

    Price

    1 day

    Duration

    Helpful?
    Yes
    No
  • K
    image-docs

    kippit

    MY

    Malaysia

    Ongoing collaboration
    5

    Awsome developer. Highly recomended

    $50

    Price

    1 day

    Duration

    Helpful?
    Yes
    No
  • N

    nate_az

    US

    United States

    5

    Excellent job. Thanks. Highly recommend

    $50

    Price

    1 day

    Duration

    Helpful?
    Yes
    No
Reviews

4 reviews for this Gig
5.0

(4)
(0)
(0)
(0)
(0)
Rating Breakdown
  • Seller communication level
    5
  • Quality of delivery
    5
  • Value of delivery
    5
Sort By
Most relevant
  • D
    image-docs

    digitalpomegran

    US

    United States

    5

    FANTASTIC! Thanks, Muhammad for helping. He has insights into mySQL and was open to the different ways we use MySQL.

    $50

    Price

    1 day

    Duration

    Helpful?
    Yes
    No
  • C

    contractor_requ

    GB

    United Kingdom

    Ongoing collaboration
    5

    A fast and excellent approach to understanding a problem which had happened, data security, and decrypting data to present well and easy to understand data reports. Also gave good insight into how a problem had arisen and sent previews of work all the way through to ensure we were inline. Highly Recommend!

    $50

    Price

    1 day

    Duration

    Helpful?
    Yes
    No
  • K
    image-docs

    kippit

    MY

    Malaysia

    Ongoing collaboration
    5

    Awsome developer. Highly recomended

    $50

    Price

    1 day

    Duration

    Helpful?
    Yes
    No
  • N

    nate_az

    US

    United States

    5

    Excellent job. Thanks. Highly recommend

    $50

    Price

    1 day

    Duration

    Helpful?
    Yes
    No