Suljettu

MariaDB DELETE SQL query taking >3000 seconds to finish

I have a DELETE query (that can't be modified) that is taking more than 3000 seconds to finish. I need someone to help me optimize the database table or server so the SQL query takes much less to finish.

Please don't bid if you aren't a MariaDB guru.

Taidot: MySQL, Tietokannan hallinto, SQL, MariaDB

Näytä lisää: sql query tree structure records, asterisk call forward database sql query, sql query child child, sql query tree children, getafreelancer message sql query help needed, specialise sql query, sql query find number child elements, design sql query forum tree, simple sql query creator, delete query taking textbox php, sql query delete images, why is sql query taking so long, simple select query taking long time sql server, how to delete duplicate records in ms access using sql query, sql query taking long time to execute, select query taking long time to execute in sql server

Tietoa työnantajasta:
( 6 arvostelua ) Cambridge, United States

Projektin tunnus: #32240787

35 freelanceria on tarjonnut keskimäärin $24/tunti tähän työhön

(139 arvostelua)
8.6
(149 arvostelua)
8.6
tangramua

Hello Joseph S.,   We have 20 years of strong experience in SQL, MySQL, Database Administration, MariaDB, as a result, we can successfully complete this project.   Please, review our profile here: [login to view URL] Lisää

$25 USD / tunti
(36 arvostelua)
6.8
(275 arvostelua)
6.9
(89 arvostelua)
6.9
(52 arvostelua)
6.2
infinityex

I can solve the problem with DELETE query execution time within 1-2 hours max, I have MariaDB on my local machine and on my cloud server. 25 years experience in MySQL.

$25 USD / tunti
(68 arvostelua)
6.2
(13 arvostelua)
5.7
Truonggiang86

Hello there, i think first we need to see what kind of DELETE you're doing, if it's already good then we need to care only about the indexes to reduce the cost. Pls share me your query so we can discuss. Waiting for yo Lisää

$20 USD / tunti
(37 arvostelua)
5.7
(8 arvostelua)
5.7
(94 arvostelua)
5.5
(6 arvostelua)
5.3
(29 arvostelua)
4.8
faizansaleem1598

Greetings, I have gone through your requirements and believe that I am best fit for your work. Lets discuss further details in chat. Thanks and looking forward for your response. Best Regards. [login to view URL] https://www.f Lisää

$20 USD / tunti
(7 arvostelua)
4.4
teekayzitsi

Hi In my current Profession -I perfom the DBA and Developer duties in high traffic OLTP environment -Python programing, -Data Scraping using python, data analysis using python and R -Database development in (maria Lisää

$20 USD / tunti
(6 arvostelua)
3.7
(2 arvostelua)
4.2
(1 arvostelu)
3.5
(4 arvostelua)
2.9
abdou19890314

Can you please send me the query...... ........................................................ .......

$20 USD / tunti
(2 arvostelua)
3.1
walterjgould

Hello Joseph, How are you? I have read your job carefully and I am sure I can help you with my vast experience. I have been optimized a query execution to retrieve about 10M records with only a few seconds. I would lik Lisää

$25 USD / tunti
(2 arvostelua)
2.8