Find Jobs
Hire Freelancers

Advise on reducing the load time of site.

$30-250 USD

Terminado
Publicado hace casi 9 años

$30-250 USD

Pagado a la entrega
I am looking for somebody proficient in php, mysql, and general server management to make the necessary modifications to the site attached to this project (included is database structure & php elements), and/or provide the appropriate advice that will result in faster load times. Essentially, the site this code is run on receives up to 300,000 uniques per day, each of which result in an entry to the DB, and when the DB has >60,000 entries, the site begins running slowly (4 core 3.5GHz taking >8 seconds to load, or timing out, because ~100% of the CPU is being used by mysql). I do not know if this is something to do with the coding of the database/site, or whether the sql connection limit is causing a backlog of requests, however once the CPU is fully loaded and the site is running slowly, if I truncate the tables, speed returns to normal (<1s average). I have a suspicion that there is some fix which will result in me not requiring such a powerful server to host a 500kb web page, despite the high volume of requests. Hopefully someone to provide insight on how to go about minimising load time, because all I keep reading is that the amount of entries in the database should have a negligible effect on serve/write speed. I’d imagine this isn't a particularly time consuming task, so bids should probably stay under $50, but if you know what needs doing, and it requires more time, then just say so and we can sort something out! I’ll not be back on Freelancer until about 8 hours after posting this project, so I’ll answer any questions anyone has then! Thanks, Harry PS, please include the word ‘monkey’ in your bid so I can separate the bottled bids from real people :)
ID del proyecto: 7896459

Información sobre el proyecto

12 propuestas
Proyecto remoto
Activo hace 9 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
Adjudicado a:
Avatar del usuario
Hello Your database structure looks like it needs some optimizing. Let's try it. If it won't work I won't need any payment. Thank you
$55 USD en 1 día
5,0 (161 comentarios)
6,9
6,9
12 freelancers están ofertando un promedio de $106 USD por este trabajo
Avatar del usuario
monkey. Hi, I estimate it to be around 1 hour of work, but it may be more or less, depending on your actual problem. give me your script and db layout so I'll take a look and will tell you how much it will cost to fix
$99 USD en 3 días
5,0 (310 comentarios)
9,0
9,0
Avatar del usuario
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably you will get a quick response from my end.
$309 USD en 10 días
4,8 (55 comentarios)
7,1
7,1
Avatar del usuario
Hi I have experience on website speed optimization. I can optimize your website to load within minimum seconds and get expected rank on Google PageSpeed insight, Pingdom, GTMetrix, etc. There are more than 10 issues including CSS, JS, Images to be solved without changing any feature. I will provide free CDN server (dns) to speed up website. (if required) I have completed many website successfully with customer full satisfaction. Would like to discuss more details. thanks. mizan
$66 USD en 4 días
4,9 (122 comentarios)
6,8
6,8
Avatar del usuario
"monkey" hi. kindly look at my profile and I believe I can help you with this. cheers.
$39 USD en 1 día
5,0 (55 comentarios)
6,5
6,5
Avatar del usuario
monkey hi. i understand your issue. Well. I can help and improve the performance. Thanks!
$77 USD en 3 días
5,0 (97 comentarios)
6,4
6,4
Avatar del usuario
I checked the db structure and the pages. Have them running on my server. I'm very expert on administration of Linux/MySQL/PHP systems, so it won't be difficult to fix this issue. I may be asking you to check something in your server anche tell me the results, or, if i could be allowed, I may check myself if you could allow me to enter (maybe via Teamviewer). I'm available in chat anytime.
$66 USD en 1 día
5,0 (9 comentarios)
4,5
4,5
Avatar del usuario
HI, There can be many reasons for slowing down a site. With your description given we think that its a database issue as when you truncate table site speed returns to normal. There can be many reasons for mysql slow queries. We can have a log of slow queries provided my mysql and see where we need to optimize queries or change schema. If we need to change schema then it may take time as we may need to change code as per schema. Lets discuss more on chat. Thanks and Regards Vibearning
$49 USD en 3 días
4,9 (7 comentarios)
4,2
4,2
Avatar del usuario
Hello, friend can analyze the php code as well as the configuration of your database, whether it is optimized, need to know if your database is on the same server as your application php or separate bank? I need to know if your server works with Apache or Nginx, although in often the bottleneck ends up occurring due to the use of Apache, not by poor quality of php code if the issue from the server after you analysis, I can report as well mount server with Nginx, and need to know which version of the Linux operating system is used. Without further.
$66 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
Nottingham, United Kingdom
5,0
3
Forma de pago verificada
Miembro desde oct 17, 2010

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.