Examine my MariaDB Table, Data, Queries, and Indexes and optimize/suggest to speed things up.

$10-30 USD

Completed

Posted

over 3 years ago

$10-30 USD

Paid on delivery

I have a MariaDB 10.4 database, with very small amounts of data (3000 rows, 400 megs, etc..). And it's performing very slow. The culprit is most likely a horrible query, probably incorrect structure, and missing or incorrect indexes. I need your help. I will provide you with a SQL file that contains my data, and also the query I am doing. Your job will be to analyze the query, figure out how to optimize it, along with table/data structure, and also which indexes to create to increase performance. Then explain to my how I did everything wrong, what the right way to do it is. Please only bid if you are truely an expert in MySQL/MariaDB optimization and not just "mediacore" or "kind of OK at it". Thanks.

MySQL

Database Administration

Database Development

Database Programming

MariaDB

Project ID: 26913993

About the project

2 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@JorabiX

I have extensive experience examining databases, I can examine and see if you need an index, in addition to improving the existing queries, with alternatives (including the new indexes)

$30 USD in 7 days

0.0

(0 reviews)

0.0

2 freelancers are bidding on average $25 USD for this job

@vinodkumar7594

Hi Client, I have 3+ years of experience in SQL development. I handled complex queries with large datasets. Please reach out on chat we can discuss and can help you. Thanks, Vinod

$20 USD in 2 days