Find Jobs
Hire Freelancers

Inefficient SQL queries slowing down WordPress site

$250-750 CAD

Completed
Posted over 5 years ago

$250-750 CAD

Paid on delivery
We have built a system with WordPress, and are using the Quick Chat plugin ([login to view URL]) to host live Q&A sessions for our subscribers. When more than 6 or 7 logged in users are using the chat system, it begins to slow down, until the site becomes unresponsive. The hosting company have said it is due to most of the load and slowness coming from inefficient sql queries. It is being hosted on a dedicated VPS. We are looking for someone to resolve the issue.
Project ID: 17876234

About the project

16 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello, I always provide fastest results with quality. I have an experience of more than 10 years in web development and maintenance. I have in-depth knowledge of php, mysql, javascript , jquery, payment system integrations, API's, css, html, html5, wordpress. I will look forward to discuss with you. Thank you.
$250 CAD in 1 day
4.7 (334 reviews)
8.2
8.2
16 freelancers are bidding on average $437 CAD for this job
User Avatar
Hello there, Myself having has 10 + years experience of web site development. Expert in Custom programming in php / Mysql / Jquery / Wordpress/ Joomla / OSC / Magento /OpenCart / Android / Mobile development / Responsive. Ready to start the work immediately. I am confident to handle your projects with dedication and good quality. Thanks and regards, Harpreet Singh
$400 CAD in 7 days
4.9 (279 reviews)
7.6
7.6
User Avatar
Hi I can fix this problem and make it work. Please hire me. Thank you ! .
$300 CAD in 5 days
4.9 (651 reviews)
7.2
7.2
User Avatar
Hey Hi there. Maybe a bit of SQL tweak is required which i am proficient at. Also i'd be looking at the logs to investigate thoroughly (if you can provide access to server). Thanks
$277 CAD in 1 day
5.0 (261 reviews)
6.9
6.9
User Avatar
Hi, I have read your exact requirement in which you have mentioned that you want your existing site ( specially chat system ) should be more speedup. I have checked the performance of the complete site which is very slow. I have checked the current performance of chat page on gtmetrix where the score is 7.5S and the score is also slow. I will optimize the complete site and server so the load time will be reduce and will achieve a very good score for mobile and desktop both. Following some steps so we can increase the speed of site: 1. compression 2. caching (in caching ...pagespeed ,varnish ,redis if root detail available) 3. leverage browser caching 4. optimize images minify css and js 5. add expires headers 6. database optimization etc Regards Karuna
$350 CAD in 3 days
4.9 (159 reviews)
6.8
6.8
User Avatar
Hi, Am Muhammad Ghaffar. I have more then 7 years experience in wordpress designing and web development I have read your project details sure am able to do that but I have some questions to ask so please message me asap thanks
$400 CAD in 10 days
4.8 (190 reviews)
7.0
7.0
User Avatar
Hey, can you answer some questions? when you setup the environment in VPs did you configure MySQL? did you checked the MySQL using MySQL tuner?
$250 CAD in 3 days
5.0 (2 reviews)
4.0
4.0
User Avatar
Hi, The issue reported by you may not be only because of inefficient queries, there are many reasons for which your website may respond slow. The load and number or request per second on the server also come into the picture. I'm a professional web developer. I've experience building distributed and resilient web application. Please initiate a chat to discuss more about the complete architecture of the web application. Regards, Akash
$555 CAD in 10 days
4.8 (3 reviews)
3.5
3.5
User Avatar
Hello, Hope you are doing well. I am pleased to introduce myself and my company, Greetings From CodeWorldTechnologies. We are excited to get to work on your new website, and We think your idea is great and we have expertise in this field. We have no doubt that it would be used heavily by families. We want to make sure you’re satisfied with our proposal and have a full understanding of what to expect in this process. Creating a website using CSS, Graphic Design, HTML, PHP, Plugin, MYSQL, Website Design, WordPress, JAVA, JAVASCRIPT, Electronic Forms, PDF is exciting, and our expert team is fully capable of giving you something unique and in the latest version that will help grow your business. And these are one the best technologies for a website development. Being an experienced agency of 9+ years, this is our bread and butter. The proposal is to let you know that we will set a project roadmap from start to finish. You will have a complete understanding of the process and timeline for completion. I would be really appreciated, If you will open a line of chat, I can represent my work behavior, development cycle, and coding format.
$555 CAD in 10 days
3.1 (14 reviews)
4.3
4.3
User Avatar
$300 CAD in 2 days
4.9 (2 reviews)
2.0
2.0
User Avatar
I've worked on large systems (serving Millions) with MySql and had to do multipel optimizations. We need to talk to know more and to better estimate how long would it take, (it all depends on how is the current schema and What are the resources we have)
$555 CAD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Vancouver, Canada
5.0
1
Payment method verified
Member since Oct 1, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.