Find Jobs
Hire Freelancers

Database Query Update

$30-250 USD

Dokončeno
Zveřejněno skoro před 10 roky

$30-250 USD

Zaplaceno při doručení
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.
IČ projektu: 5942407

O projektu

10 nabídky
Vzdálený projekt
Aktivní před 10 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
Uděleno:
Avatar uživatele
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 v 0 dni
4,9 (125 recenze)
6,3
6,3
10 freelanceři nabízejí v průměru $175 USD za tuto práci
Avatar uživatele
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 v 2 dnech
5,0 (58 recenze)
7,4
7,4
Avatar uživatele
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 v 2 dnech
4,9 (95 recenze)
7,1
7,1
Avatar uživatele
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 v 3 dnech
4,8 (136 recenze)
6,8
6,8
Avatar uživatele
Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready !
$250 USD v 3 dnech
5,0 (30 recenze)
6,7
6,7
Avatar uživatele
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 v 7 dnech
4,9 (20 recenze)
5,6
5,6
Avatar uživatele
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 v 3 dnech
5,0 (6 recenze)
4,4
4,4
Avatar uživatele
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 v 2 dnech
4,9 (5 recenze)
4,2
4,2

O klientovi

Pochází z UNITED STATES
Charleston, United States
5,0
14
Ověřená platební metoda
Členem od kvě 14, 2014

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.