Mysql Laravel expert Need -- 7

$30-250 USD

Zaprt

Objavljeno

pred več kot 3 leti

$30-250 USD

Plačilo ob dostavi

Making a little website with my Laravel. Clicking on the home page makes the CPU very high. I need a Laravel Mysql Expert. SELECT * FROM posts WHERE status = 1 AND posts.worker_need> (SELECT COUNT (id) FROM prove WHERE job_id = [login to view URL] AND (status = 0 OR status = 1)) Here is the second condition that I am counting = (SELECT COUNT (id) FROM prove WHERE job_id = [login to view URL] AND (status = 0 OR status = 1)) With this query the whole server CPU becomes 100% just for this I wanted to know if there is any other way to do the count work where there will not be so much server load. SELECT * FROM posts WHERE status=1 AND posts.worker_need > (SELECT COUNT(id) FROM prove WHERE job_id=[login to view URL] AND (status = 0 OR status = 1))

ID projekta: 28256438

Več o projektu

9 ponudb

Projekt na daljavo

Aktivno pred 3 leti

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

9 freelancerjev je oddalo ponudbo s povprečno vrednostjo $61 USD za to delo

@zimenkoilya2

Hello , I have 7 years of experience in web development inclduing o laravel o html o javascript o sql o web design etc... when read your project description , It sounds interesting to me I do have skills & experience that are required to complete it to a high standard.I am ready to work for you now and can provide you perfect result according to your requirements. Please initiate over chat for further discussion Thanks

$140 USD v 7 dneh

4,9

(26 ocen)

5,5

@Hiralkapaletiya

Dear sir/mem, Hope you and your family doing well, I’m Hiral a senior full-stack developer. I just read your project requirement and I'm happy to work in this please give me this opportunity I will never disappoint you My motto is delivery on time with great quality while meeting customer’s quality as they want. I guarantee the quality of my result and I will do my best to satisfy you. As far as I'm concerned, I'm the most qualified for this job. I promise the best quality on time and 24/7 communication. My 5+years of experience includes the following areas: PHP, HTML, UI/UX,CSS,spm,MySQL, jQuery, Ajax, Javascript,blockchain,CodeIgniter(Framework), wordpress,c#,asp.net(core)(MVC),.net, Angular,Laravel(Framework), Vue JS, swift code,iOS, android, react native, flutter,Stripe API(Payment Gateway), Paypal API(Payment Gateway), ccavenue (Payment Gateway) Twilio, CMS, AWS, Google API, Facebook API. Thank you Hiral kapalatia

$50 USD v 1 dnevu

5,0

(15 ocen)

3,8

@Digiwebexpert

Dear Sir, Had you created index on tables? how much data is present in table? what all values status column contains? Regards, Sachin

$35 USD v 2 dneh

5,0

(6 ocen)

3,2

@seooffpage

Greetings! I have 7+ professional experience in laravel. We have completed more than 100+ projects in laravel. My SKills: Laravel, CakePHP, Yii, React, Vue, Codeigniter. I'm fully familiar with laravel old version to the latest version of laravel. I can start your project immediately. Kindly discuss on chat regarding more clarification about your task. Thanks Narayan

$140 USD v 2 dneh

3,2

(5 ocen)

2,4

@amit718

Hello, I can make your query faster. I am Web developer with 5+ years of experience in PHP, Angular, Codeigniter, Laravel, Zend, Mysql, HTML, CSS, Javascript, JQuery, Third party API, Curl. Let's Have chat for further discussion.

$30 USD v 1 dnevu

5,0

(2 ocen)

1,0

@Abdulmalik795

Hello, I've seen your project on Msql Laravel several times, I thought you would have find an expert, i can help you solve this issue. With me, you will get and expert in your disposal. Thanks

$30 USD v 1 dnevu

0,0

(0 ocen)

0,0

@roshanthedev

I've been working with PHP based applications that deals with raw MySQL queries over two years. I've also worked in few Laravel applications. I can optimize the queries above to achieve the maximum possible performance. If you're interested in hiring me, we can discuss further details in chat.

$40 USD v 2 dneh