MYSQL query optimize

Kapalı İlan edilme: 5 yıl önce Teslim sırasında ödenir
Kapalı Teslim sırasında ödenir

I want to optimize my MySQL query. I have developed application in java, but when I run the query its take too much time. I want to reduce the time for result. Query sample attached.

Java MySQL

Proje NO: #18143097

Proje hakkında

19 teklif Uzak proje Aktif 5 yıl önce

Bu iş için 19 freelancer ortalamada ₹6768 teklif veriyor

techwelfare

we are mysql expert team. plz award us for the project

₹9484 INR in 6 gün içinde
(74 Değerlendirme)
6.4
paulprabhakarand

Hi, I am a database developer and working for a big software company at Bangalore. I handle different databases like MYSQL, Oracle and PostgresSQL. Often I handle this kind of issue for different developers in our com Daha Fazla

₹7000 INR in 3 gün içinde
(34 Değerlendirme)
5.7
BitSDestiny

With my 9+ years of Software Development experience like to work on your project,Please see my reviews to consider me as your development member. ASP.Net, C#, VB.Net, MVC, WPF,Android Application,iOS Application, Vi Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(8 Değerlendirme)
4.8
JawadIT

I can optimize it. It requires the index to be applied over 2 tables and a join has to be removed also. You may contact for details.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(34 Değerlendirme)
5.0
mail2vimalarora

Hello, I am ready to discuss project with you. Being experienced in working on several databases and also performance tuning tasks, I can help you in optimizing code you have in MYSQL. I am available to start now a Daha Fazla

₹3333 INR in 3 gün içinde
(31 Değerlendirme)
4.9
digitalfog

I love MySQL :) Good day! I have all the necessary knowledge and experience to help you with this task. Fast, cheap and high quality. I always finish the work and provide support.

₹7777 INR in 0 gün içinde
(19 Değerlendirme)
4.8
AndreyBarykin

I have big experience as Senior Database Developer/DBA. I Know well SQL and query optimization. Please give me full text of query, I analyse and answer, can I help you...

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(2 Değerlendirme)
3.0
FERDOUSayoub

Hello, I'm a software engineer. Certified on java SE 8 . I have more than 4 years experience on Java programming. My first interest is code quality. I work now for one of the biggest IT companies in Europe. I work with Daha Fazla

₹7000 INR in 7 gün içinde
(1 Yorum)
2.2
coriandercode

Welcome to my profile. I'm rich experienced with the developments of Desktop & Mobile App and Website . Your satisfaction is a duty for me, so I'll do our best on your project. ? 8+ years of experience in dev Daha Fazla

₹7777 INR in 3 gün içinde
(2 Değerlendirme)
1.9
nikhilgarg855

I have been working with IT firm for the past 4+ years as a senior QA analyst. This is one of the key areas in which I have worked with everyday to optimise the sql queries.

₹6666 INR in 3 gün içinde
(0 Değerlendirme)
0.0
Scribtor

I'll do this in a matter of few hours. Please send the full query in txt format so that I may optimize it best

₹12222 INR in 3 gün içinde
(0 Değerlendirme)
0.0
anpradeepk

good skill in query writing it will take 2 days to finish one days for understand the query operation and another day for finish the query.

₹7230 INR in 2 gün içinde
(0 Değerlendirme)
0.0
kasunse

It seems that you need to optimize the query. There are many modern techniques to optimize this query, and it is very easy with it. I can optimize your mysql line to top speed level. It may specd about few hours to do Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
0.0
ankushagarwal87

Hi I can help you with what you need. We can discuss more about it over chat.

₹5555 INR in 3 gün içinde
(0 Değerlendirme)
0.0
mayank19in

Working as a DBA with devlopment and enjoy the DB and query tuning so give chance.

₹5555 INR in 3 gün içinde
(0 Değerlendirme)
0.0
edokanoi

Strong knowlejgw in dafa asde . lzserver

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
0.0
adityamittal1993

Hey, I have good experience in optimizing MySQL query response time to between 30-100 ms. Aditya

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
0.0