Find Jobs
Hire Freelancers

Database Query Update

$30-250 USD

Completed
Posted almost 10 years ago

$30-250 USD

Paid on delivery
I need to update/optimize my existing website, specifically how it queries/fetches data from the database. My web host suspended my website due to "heavy load" on their servers. They pointed to my outdated method of how we query the database. They said I need to to "optimize it" (their words). I have a very basic rudimentary news posting system and I've currently disabled this on my site. The site is up and running now to let visitors access other parts of the website, but the news is disabled. So I'm looking at getting the code updated and getting the news section back live on the website again. The web host complained on a specific string of code (I'll include this string below). This string shows up only in 5 files on my entire website and it needs to be improved/updated (according to my web host) So I'm not looking for a major overhaul in any way, only to get the news section back up and running again, without my web host suspending my account again, once traffic picks up. I've gotten other "warnings" from the web host in the past, that when I get a lot of traffic on the site there are too many connections to the database (they remain open?) The allowed number of connections to the database "max out". So this sounds to me like when a user connects to grab data from the database, the connection is not closed, but remain open and when we get a lot of hits, the server experience a heavy load. The concerned piece of code that the web host support mentioned to me is the following: "SELECT * FROM article_table ORDER BY id DESC" "The script is causing a heavy load on the server" they said. On the front end of things, the visitor only connects to the database when they visit the front page "[login to view URL]" and "[login to view URL]", this shows our news postings. I also have 3 admin files that use the same code: /admin/[login to view URL] /admin/[login to view URL] /admin/[login to view URL] Since only a few admins (3) connects to these 3 files however this shouldn't (technically) be an issue. However if there is a "better" way of connecting to the database, get data and then disconnect from the database, then that is what I'm looking for. This is a minor update project. I'll add the files that this is concerning, in an attached rar archive. If more information is needed regarding the connection to the database or the problem in general, please let me know. It's a bit difficult to describe it, but I hope that it makes sense. Thanks.
Project ID: 5942407

About the project

10 proposals
Remote project
Active 10 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
hi, i've looked over your files and indeed there're some things which are not done as they should. I can fix your errors and prevent server overload. cristian
$77 USD in 0 day
4.9 (125 reviews)
6.3
6.3
10 freelancers are bidding on average $175 USD for this job
User Avatar
Hi, I've just checked your script and it's looks like fine to me. I have a question. How many row of article did you have in your database? I think you have a bunch of database entry and it's overloading the server to load in a single query. I can fix this easily but i need more information. Thank You.
$111 USD in 2 days
5.0 (58 reviews)
7.4
7.4
User Avatar
Hello Project Manager, This project seems similar to the one I just placed a bid on. Anyways I am John Ofagbe a professional web developer. I have gone through your project description and I understand that you need to optimize your SQL queries. I can get this done within 48 hours. Best regards, John O.
$120 USD in 2 days
4.9 (95 reviews)
7.1
7.1
User Avatar
I am specialize in C++,C#.net,ASP.Net,JAVA, PHP, MySQL, Wordpress, e-commerce websites and portals, payment gateways and customized web based applications. my aim to deliver quality products to our customers within specified deadline. CHECK MY PROFILE AND REVIEWS. i strongly believe in Quality work. If hired by you I will put in my best work. I am ready to be hired by you and start work on your jobs. PM to me for more discussion
$136 USD in 3 days
4.8 (136 reviews)
6.8
6.8
User Avatar
Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready !
$250 USD in 3 days
5.0 (30 reviews)
6.7
6.7
User Avatar
Hi, I can solve this bug and speed up your website , I have excellent work exp , Please contact me for the same. Thanks
$250 USD in 7 days
4.9 (20 reviews)
5.6
5.6
User Avatar
Hi, Looks like you need to optimize your database using indexes. As welll as you need to establish a cron job to purge unwanted data. Please contact us to further discuss this . Regards
$111 USD in 3 days
5.0 (6 reviews)
4.4
4.4
User Avatar
Hello I have seen your problem I can do it. Lets have a chat in PM and I can definitely assure you that I will be helpful. It will be just a 2 min you will be decide if I will be able to do it or not.
$222 USD in 2 days
4.9 (5 reviews)
4.2
4.2

About the client

Flag of UNITED STATES
Charleston, United States
5.0
14
Payment method verified
Member since May 14, 2014

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.