Find Jobs
Hire Freelancers

Database Query Update

$30-250 USD

Cerrado
Publicado hace casi 10 años

$30-250 USD

Pagado a la entrega
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.
ID del proyecto: 5942420

Información sobre el proyecto

22 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
22 freelancers están ofertando un promedio de $144 USD por este trabajo
Avatar del usuario
A proposal has not yet been provided
$147 USD en 3 días
5,0 (47 comentarios)
6,3
6,3
Avatar del usuario
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 en 3 días
4,9 (66 comentarios)
6,0
6,0
Avatar del usuario
Hello, can you provide URL to you web site to review, and make more accurate time/cost estimation -- Alexey
$45 USD en 3 días
5,0 (49 comentarios)
5,7
5,7
Avatar del usuario
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 en 2 días
4,9 (34 comentarios)
5,5
5,5
Avatar del usuario
Your database requires optimization, data duplication and non-indexed table fields are common causes of this issue.
$100 USD en 3 días
5,0 (29 comentarios)
5,2
5,2
Avatar del usuario
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 en 2 días
4,9 (25 comentarios)
5,2
5,2
Avatar del usuario
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 en 7 días
4,9 (96 comentarios)
5,1
5,1
Avatar del usuario
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 en 5 días
4,1 (4 comentarios)
5,0
5,0
Avatar del usuario
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 en 3 días
4,9 (21 comentarios)
4,6
4,6
Avatar del usuario
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 en 3 días
4,8 (9 comentarios)
4,6
4,6
Avatar del usuario
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 en 0 día
5,0 (7 comentarios)
4,4
4,4
Avatar del usuario
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 en 0 día
4,8 (17 comentarios)
4,0
4,0
Avatar del usuario
A proposal has not yet been provided
$206 USD en 6 días
5,0 (6 comentarios)
3,4
3,4
Avatar del usuario
A proposal has not yet been provided
$100 USD en 2 días
5,0 (3 comentarios)
2,4
2,4
Avatar del usuario
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 en 3 días
5,0 (2 comentarios)
2,1
2,1
Avatar del usuario
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 en 1 día
5,0 (3 comentarios)
1,7
1,7
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
1,5
1,5
Avatar del usuario
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 en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$111 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
La propuesta todavía no ha sido proveída
$144 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de DOMINICAN REPUBLIC
Santo Domingo, Dominican Republic
0,0
0
Miembro desde may 14, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.