MariaDB DELETE SQL query taking >3000 seconds to finish

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: https://www.freelancer.com/u/tangramua Here detailed information about our company, our portfolio, and the client's recent reviews.   Also, we wanted to personally discuss questions about your project, which helps us to give you the right estimation.   Best regards, Tangram Canada Inc.  

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.

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 your response if interested. Thank you!!!

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 (mariadb,Mysql,Postgres,SQlite and SQl) -Data Mining -Automation -Data warehousing on sql,mysql and postgres database (Star Schemas) and Business Intelligence systems development -Data extractions using Talend Open Studio,Python -Data Intergration using WSO2 ,Talend Open Studio -I have rich experienced in Database Administration, Excel -Data visualisation using Power BI,BIRT ,Jasper ,excel -SQL server installations I am looking for the clear final requirements docs of your project so that I can start working immediately. If you need to discuss with me for any kind of suggestions or information, please knock me anytime. I am looking forward to hearing from you I can assure that if you work with me once, you will always work with me on these kind of projects and I can deliver quality and superior work at a price we are both comfortable with and within the agreed timeline. Kindly consider my bid.I will do whatever it takes to complete this project and earn a 5 star rating from you as well Kind Regards Takudzwa

Hi! This is a typical index problem. You have to review the related tables and how they are linked. And check if there are other additional topics, such as triggers for example. If you like, we can talk about it by chat. Thanks!

Hi there. I'm a system admin with 20+ years experience and I worked a lot optimizing SQL queries for developers in all kinds of databases, Oracle, mySQL, MariaDB, Postgres. It would be great to have more information about structure, number of records, etc. in order to fully understand the problem and the complexity involved. Chat me whenever you want and I'll gladly take a look.

Hello, I am experienced database developer and administrator for MySQL and MariaDB which is a version of MySQL. I can help you with the database Query optimization. I have done very performance review and optimization for large Databases. Looking forward to get some more information to get started with it. Thanks

*** SQL QUERY EXPERT *** Hi :) Thanks for your job posting. This is Steven. I've read your project detail and I'm very interested in your project. As skilled fullstack developer,I've rich experience in SQL QUERY(MySQL, MariaDB). This is my Profile: https://www.freelancer.com/u/stevepol Once you contact me,you will get perfect result within your time. I am looking forward to hearing from you. Best regards! Thanks

Optimization is my favorite field. I want hear more. Anyway, no problem, don't worry. Let us discuss this soon.

Hi, I can help you fixing your issue(without change query). In the past I had problems like this, and I alwais find a solution. maybe we can chat to get details about issue.

Hello. Above all, I'm really happy to see you energetic from the danger of Covid-19. I have been working as a freelancer for +6 years and I majored about data constructure design and SQL. So I can finish your project successfully. During working I have done many projects similar to yours and have received excellent reviews. I will respond as flexibly as possible. Please feel free to contact me as soon as possible. You can basically contact us at any time. If you give me a job, I'll do my best not to be disappointed. Thank you

Hi there, I'm expert in SQL and Python. and Currently working as a Data Engineer. I'll do this task for the minimum fees. What about that? M. A. Elmougith

I have an about 5 years of experience as oracle PLSQL developer also have an experience in query optimization

Hi, How are you? I have rich commercial experince in maintaining website on dedicated server and vps for Linux. And I know how to optimize db structur and good tuning knowledge. Let;s discuss viacht. Thanks

Hi there! Please check my attached CV. I like long-term contracts, I'm UTC-6 time zone. I'm used working from home and because of that, I'm well organized and highly disciplined to exceed your expectations. I am passionate about software development...it’s not just my career, it’s my hobby. I have more than 12 years of experience. I'm based in Costa Rica, Central America; one of the most educated countries in the whole of Latin America. I'm constantly striving to learn new things and improve. I DO follow industry news, regularly tinker with new technologies, and read books and blogs to keep my skills current. - I work well alone or within a team environment and enjoy working with my colleagues. - I always use GitHub to keep track of my code and push commits daily - I am fluent in English and Spanish and I'm learning German as a third language, I always write documentation for the code I write and comments. Let's discuss further details on the chat. Other Important Skills Passionate, Motivated, Enthusiastic, Willing to learn, Team player, Well Organised, Thinking out of the box, Great communication skills, Multifaceted, fast-learning, logical thinker.