Completed

PHP developer required to eliminate duplicated database requests generated from a WordPress plugin

The problem:

---------------------

I manage a job-board website which runs on wordpress and a pre-built job-board plugin. Although the loading speeds of the static pages are relatively quick, any dynmaic content delivered by the pre-built job-board plugin (e.g. searching for jobs or filtering the results) is slow.

The cause of the problem:

------------------------------------------

When the pre-built job-board plugin is used, it generates a large number (approx. 800) of different queries. This itself isn't an issue, however, of these ~800 queries, approx. 120 of them request the exact same section of code from the database (please see the attached image - the code which is getting called 120 times is shown under the 'Caller' column).

Without going too into the maths, processing one of these requests takes 70ms, so with it being duplicated 120 times, in total it increases my server response time by around 8.4s.

What I'm after:

------------------------

I'm after a competent PHP programmer who can go into the code and fix this.

Requirements:

-----------------------

For the project to be successful, the two following criteria will need to be met:

1. The additional 8.4s server response time is removed, either by eliminating the repeated requests or through other suitable programming means.

2. The functionality of the website and plugin remains untouched - i.e. after your amendments, other than being quicker, the front and backend of the website and plugin should still look and perform in the exact same way as they do now.

I'm aware that this isn't exactly a complex issue and won't be anywhere near the hardest project you've worked on, however, please do let me know if you have any questions. If at all helpful, I can provide you with a database log of the queries and associated requests (including the repeated ones) generated by the plugin.

Thanks for taking the time to read about the project,

Guvy

Skills: PHP, WordPress, MySQL, HTML, CSS

See more: php developer required matrimonial site video chat, freelancer php developer required lahore, parttime php developer required, how to use query monitor, wordpress duplicate queries, remove unused css wordpress without plugin, wordpress slow database queries, wordpress cache database queries, optimize wordpress database queries, wordpress database calls, wordpress database indexes, php developer required jaipur, freelance php developer required, php developer required project, php developer required freelancer, experienced php developer required, core php developer required, php developer required baroda, php developer required in indore, php developer required

About the Employer:
( 2 reviews ) Bedford, United Kingdom

Project ID: #23994399

Awarded to:

coolguyinus2004

Ok the problem is the plugins Jobsearch,career framework and elementor are all those having problems with making amendments to the current query whatever you posted. I dont why you never thought its not a complex issue More

£350 GBP in 7 days
(355 Reviews)
7.7

26 freelancers are bidding on average £154 for this job

evgendob

Hello. Wordpress development expert ready to help you with project. I have more 400 good reviews and more 9 years of development experience behind, so all will be done with best quality and timeframe. Free bugfixing s More

£250 GBP in 7 days
(566 Reviews)
8.0
mituld

Hello There, how are you doing? I have read the description and really interested in this job, I have great experience doing similar jobs regarding to these skills , PHP , WordPress , CSS , MySQL , HTML Please star More

£135 GBP in 7 days
(481 Reviews)
8.2
urmi1

Hi, I did reviewed your project details . I believe that i will definitely meet your specification with my professional service. I have rich experience with wordpress template and customization , Plugin Install and cus More

£200 GBP in 7 days
(255 Reviews)
7.4
hemsingh1

CSS, HTML, MySQL, PHP, WordPress skilled professional with the required expertise. Can help to deliver the solution as needed on the expected lines. Please private message me to discuss the project further. Hope to bui More

£150 GBP in 7 days
(91 Reviews)
5.8
stevearm

Hello. My advise, it can't be fixed. This plugin has been developed wrong. You can see it uses the normal WP tables to add jobs and the posts' meta table to add attributes. It will be slow whatever you do. You can hire More

£135 GBP in 7 days
(8 Reviews)
5.6
aftabahmad334

Hello Please go through my profile and check REVIEWS/FEEDBACK AND PORTFOLIO then talk to me. I am working as WEB DEVELOPER since 2010. I have completed 300 jobs on local and international projects and more then 100 pro More

£135 GBP in 7 days
(35 Reviews)
5.3
stepinnsolution

Hello Sir, I have more than 10 years of experience in Web & App development and multiple technologies. I have gone through your requirements and am ready to complete your job. I am committed to providing you high qu More

£250 GBP in 7 days
(39 Reviews)
5.5
£150 GBP in 4 days
(13 Reviews)
4.6
Markoradoj

Dear Client! I am an experienced php developer. I've read your job description with great interest. I've fully understood what you want and if you hire me, you would get the best result. I can start work immediately an More

£135 GBP in 3 days
(14 Reviews)
4.0
peacemarketing

Hi Guvy. I'm a professional WordPress Plugin developer and working over 5 years in this field. Contact me, please. Thank you.

£135 GBP in 7 days
(8 Reviews)
4.1
Jee1980

Dear sir Thanks to give me a chance to write my proposal over here. I have studied your issues, it's just duplicated query from Plugin in the attachment. It does means that reduce the query times, using more simple log More

£160 GBP in 3 days
(5 Reviews)
4.1
adnanhusain101

Hey Guvy, Can you please share me the link of your website so I can have a clear view myself, I understood your points. I have 12 years of industrial experience. I'll be waiting for your response to have effective co More

£150 GBP in 3 days
(2 Reviews)
3.6
nutankumarftp

Hello Sir/Mam, I have read your post requirement for the "Without going too into the maths, processing one of these requests takes 70ms, so with it being duplicated 120 times, in total it increases my server response t More

£100 GBP in 7 days
(9 Reviews)
3.7
sanjaykoraka

Hello Guvy, I read your requirements and understand very-well and ready to start work from now. I am new here but have 10+ years experience sir. This is my main profile link - https://www.freelancer.com/u/dynamite More

£100 GBP in 4 days
(6 Reviews)
3.2
virendrastarone

We are expert in front end as well as back end also. High Quality + Fast Speed = Excellent Result + Business Success, this is my working style. I have gone through your Job post and I can understand your job requiremen More

£90 GBP in 7 days
(9 Reviews)
3.7
techsolup

HI... I have gone through the project description it's just duplicated query from Plugin in the attachment picture. It means that reduce the query times, using more simple logic and long query, I understood. I can Sol More

£250 GBP in 7 days
(5 Reviews)
2.9
twentyten10

IAM highly skilled in debugging and fixing php code.I have done many projects like this. My reviews speak for my smart work and. My skills. If awarded I will deliver on time

£120 GBP in 7 days
(2 Reviews)
2.7
shahzaibpro

Hey there, I see you’re looking for somebody who are experienced graphic designer and web designer for your business Nano Journey … I have 5+ years of experience in Adobe Photoshop, Illustrator, UI/UX, JS, Bootstrap, H More

£135 GBP in 7 days
(3 Reviews)
2.4
sigbl

Dear Mr. Guvy! Thank you for sharing the details in depth. We have got the visual of the root cause and would like to discuss the solution over the chat along with few follow-up questions. Looking forward to hearing More

£135 GBP in 7 days
(4 Reviews)
2.2
technikalguru

Hello Guvy, I'm a web designer & developer and I have hands-on experience in developing websites for different types, and I can fix the issues and make it faster and better. see my previous work : [login to view URL] More

£70 GBP in 5 days
(1 Review)
0.7