Find Jobs
Hire Freelancers

Database Query Update

$30-250 USD

Closed
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: 5942420

About the project

22 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
22 freelancers are bidding on average $144 USD for this job
User Avatar
A proposal has not yet been provided
$147 USD in 3 days
5.0 (47 reviews)
6.3
6.3
User Avatar
Hello, Nothing is so simple as you point out. First of all, I would need access to your database to see the table structure and then I will need FTP access to see how your script connects to the DB. I can rewrite part of your code and fix the issues. If you have millions of entries in the DB and have tens of thousands of visitors a day then any amount of fixes won't solve your problem. You will need a new vps or DS. However, I fixed things in the past and got a 10x speed increase. If you have any questions, just ask. Regards, George
$155 USD in 3 days
4.9 (66 reviews)
6.0
6.0
User Avatar
Hello, can you provide URL to you web site to review, and make more accurate time/cost estimation -- Alexey
$45 USD in 3 days
5.0 (49 reviews)
5.7
5.7
User Avatar
Hello, SELECT * is bad to do it's worst query possible. I can fix this out for you but problem could be in database also, you might need database normalization. So I'm not sure but you could be in need of entire new database, and I'd have to see your code. This could be too big job. But if problem is in this query I can probably fix it in a day or two. But I'd need to see whole code how it queries database, so I know better. You didn't send any rar file, but I'd like to see it. Regards, Predrag
$126 USD in 2 days
4.9 (34 reviews)
5.5
5.5
User Avatar
Your database requires optimization, data duplication and non-indexed table fields are common causes of this issue.
$100 USD in 3 days
5.0 (29 reviews)
5.2
5.2
User Avatar
Hello Project Manager, I am John Ofagbe a professional web developer. I have gone through your project description and I understand that you need to optimize your queries. I can get this done for you within 48 hours. Regards, John O.
$120 USD in 2 days
4.9 (25 reviews)
5.2
5.2
User Avatar
hi, my name is shahid, i am working in web development from past four year. Will provide you quality work and hopefully we will have long term relationship in web development. let me know if i can help you. thanks
$250 USD in 7 days
4.9 (96 reviews)
5.1
5.1
User Avatar
Hi, The query you have mentioned is quite simple, the only thing that can put load on your server is that you are fetching all the data from the `article_table`. Is is possible if we fetch in chunks? like in pagination etc form? I'd like to see the code first in order to give you a solution. Looking forward to your reply Thanks
$100 USD in 5 days
4.1 (4 reviews)
5.0
5.0
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. 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.
$143 USD in 3 days
4.9 (21 reviews)
4.6
4.6
User Avatar
Dear jcunix007, My name is Sunny, and I am a Website Developer by profession. I came across your project posting and thought of writing to you. I have read all your requirements and interested to update/optimize my existing website, specifically how it queries/fetches data from the database. Our team has an experience of approx. 5 years and has developed close to 200 Websites & Portals till date. We are efficient in creating fresh, clean, elegant & corporate designs for websites as well as themes using GUI, HTML5, CSS3, jQuery & Bootstrap. We work on responsive websites (Front-end & Back-end) and Mobile Applications (Android & IOS). In addition, we are an expert in PHP, CakePHP, Zend, CMS, OOPS, Ajax, JavaScript, MySQL, WordPress, Joomla, Drupal, Magento, Prestashop, CRM & others. I have few questions regarding the project and would like to discuss them with you as per your convenience. Let me know how you would like to take the conversation ahead. Thanks, Sunny (WEB DESIGN PLUS)
$155 USD in 3 days
4.8 (9 reviews)
4.6
4.6
User Avatar
Hi jcunix007, This query "SELECT * FROM article_table ORDER BY id DESC" means that get all articles in your database and depending on how many articles you have, it might be a heavy workload. The solution here is to select smaller chunk, i.e. 10, 20, 50 articles per request. If you allow me to access your code base, I could have a look at and provide the solution immediately. I hope you're online so that we can discuss quickly. Best regards
$100 USD in 0 day
5.0 (7 reviews)
4.4
4.4
User Avatar
Dear jcunix007 I'm very interested to do this task with 100% accuracy of your demand, and will be finish within very short time, because this task is very easy for me. Thanks and best regards
$100 USD in 0 day
4.8 (17 reviews)
4.0
4.0
User Avatar
A proposal has not yet been provided
$206 USD in 6 days
5.0 (6 reviews)
3.4
3.4
User Avatar
A proposal has not yet been provided
$100 USD in 2 days
5.0 (3 reviews)
2.4
2.4
User Avatar
Hi Vision Digital Solutions (VDSols) is a provider of custom web development, mobile app & digital marketing with expertise in PHP/ASP.NET, iOS/Android app, CMS, E-commerce, SEO/PPC, ROR, Portal, CMS, Drupal, Joomla, Magneto, SharePoint, C#, Social Networking Application. Catering result oriented & cost competitive solutions. Why Choose VDSols - Top IT Services provider with Skilled IT Experts -- Strong technology competency and its ongoing updates - Flexible engagement models with seamless communication - Competitive in cost while ZERO compromise in quality - Strive day in and out to meet client's Satisfaction Service Description VDSols is the provider of 1. Custom web development 2. Enterprise portals 3. Responsive website 4. Ecommerce 5. Php/Asp.net application 6. Mobile application 7. Android / iPhone Apps 8. Ruby On Rails 9. Microsoft SharePoint 10. C# 11. CMS solutions 12. Social media marketing 13. PPC and SEO services VDSols has pool of 1. Web Developers 2. ASP.NET Developers 3. Codeigniter/PHP Developers 4. Apple/iPhone/Android App Developer 5. Website coder 6. Web Programmers 7. Zend/Cakphp Developer 8. Ruby on Rails Developers 9. Drupal Developers 10. Magento e-commerce Developers Kindly provide a chance to prove ourself Thanks
$34 USD in 3 days
5.0 (2 reviews)
2.1
2.1
User Avatar
Hi Having more than 7 years of experience in Database management system such as Oracle,Mysql, prosgress database with performance optimization. i can fix your problem within a day and get back your site to normal. also have a good knowledge in PHP. ~Rameez.
$66 USD in 1 day
5.0 (3 reviews)
1.7
1.7
User Avatar
Hello, sir We are a team. We are newbabiers on this site. But we have 5 years experiences like your project. We want you to discuss it more details. Regards, shizong
$150 USD in 1 day
5.0 (2 reviews)
1.5
1.5
User Avatar
update nad optimize your existing website using new technologies, framewoks, templates and aching. Caching is used to speed up a call to display or fetch your data by saving its output to a file so if you are displaying one page of your website that does not change its content very often, it might work well and reduce query you database. On the other hand, if you are displaying a page with a timetable containing new information by the minute you will be able to configure and change the cache lifetime but you might have to upgrade your hosting plans. 100% satisfaction guaranteed
$111 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
La propuesta todavía no ha sido proveída
$144 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of DOMINICAN REPUBLIC
Santo Domingo, Dominican Republic
0.0
0
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.