Encerrado

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.

Habilidades: MySQL, Administração de Bancos de Dados, SQL, MariaDB

Veja mais: 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

Acerca do Empregador:
( 6 comentários ) Cambridge, United States

ID do Projeto: #32240787

35 freelancers estão ofertando em média $24/hora nesse trabalho

(139 Comentários)
8.6
(149 Comentários)
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] Mais

$25 USD / hora
(36 Comentários)
6.8
(275 Comentários)
6.9
(89 Comentários)
6.9
(52 Comentários)
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 / hora
(68 Comentários)
6.2
(13 Comentários)
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 Mais

$20 USD / hora
(37 Comentários)
5.7
(8 Comentários)
5.7
(94 Comentários)
5.5
(6 Comentários)
5.3
(29 Comentários)
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 Mais

$20 USD / hora
(7 Comentários)
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 Mais

$20 USD / hora
(6 Comentários)
3.7
(2 Comentários)
4.2
(1 Comentário)
3.5
(4 Comentários)
2.9
abdou19890314

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

$20 USD / hora
(2 Comentários)
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 Mais

$25 USD / hora
(2 Comentários)
2.8