Find Jobs
Hire Freelancers

Mysql Joomla overload the server

$10-30 USD

Cancelado
Publicado hace más de 10 años

$10-30 USD

Pagado a la entrega
I have a joomla site witch that have mysql overload problems, i think that the article counter its bloking the main table making a high overload on the entire server.. when a few visits came and visit the server get frezzed by the mysql.. i need help on this.. i think the problem is on this part of the code ****************************************************** SELECT [login to view URL], [login to view URL], [login to view URL], a.title_alias, [login to view URL], a.checked_out, a.checked_out_time, [login to view URL],[login to view URL], a.created_by, a.created_by_alias, CASE WHEN [login to view URL] =0 THEN [login to view URL] ELSE [login to view URL] END AS modified, a.modified_by, [login to view URL] AS modified_by_name, CASE WHEN a.publish_up =0 THEN [login to view URL] ELSE a.publish_up END AS publish_up, a.publish_down, [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL],[login to view URL], [login to view URL], [login to view URL], [login to view URL], LENGTH( [login to view URL] ) AS readmore, CASE WHEN [login to view URL] IS NOT NULL THEN 0 ELSE [login to view URL] END AS state, [login to view URL] AS category_title, [login to view URL] AS category_route, [login to view URL] AS category_access, [login to view URL] category_alias, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE [login to view URL] END AS author, [login to view URL] AS author_email, [login to view URL] AS contactid, [login to view URL] AS parent_title, [login to view URL] parent_id, [login to view URL] AS parent_route, [login to view URL] AS parent_alias, ROUND( v.rating_sum /v.rating_count, 0 ) AS rating, v.rating_count AS rating_count, [login to view URL], CASE WHEN [login to view URL] IS NULL THEN [login to view URL] ELSE 0 END AS parents_published FROM dtf2b_content AS a LEFT JOIN dtf2b_content_frontpage AS fp ON fp.content_id = [login to view URL] LEFT JOIN dtf2b_categories AS c ON [login to view URL] = [login to view URL] LEFT JOIN dtf2b_users AS ua ON [login to view URL] = a.created_by LEFT JOIN dtf2b_users AS uam ON [login to view URL] = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX( [login to view URL] ) AS id, [login to view URL] FROM dtf2b_contact_details AS contact WHERE [login to view URL] =1 GROUP BY contact.user_id, [login to view URL] ) AS contact ON contact.user_id = a.created_by LEFT JOIN dtf2b_categories AS parent ON [login to view URL] = c.parent_id LEFT JOIN dtf2b_content_rating AS v ON [login to view URL] = v.content_id LEFT OUTER JOIN ( SELECT [login to view URL] AS id FROM dtf2b_categories AS cat JOIN dtf2b_categories AS parent ON [login to view URL] BETWEEN [login to view URL] AND [login to view URL] WHERE [login to view URL] = 'com_content' AND [login to view URL] !=1 GROUP BY [login to view URL] ) AS badcats ON [login to view URL] = [login to view URL] *****************************************
ID del proyecto: 4792025

Información sobre el proyecto

7 propuestas
Proyecto remoto
Activo hace 11 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
7 freelancers están ofertando un promedio de $108 USD por este trabajo
Avatar del usuario
Please send all the details.
$35 USD en 3 días
5,0 (8 comentarios)
5,0
5,0
Avatar del usuario
Let expert do this
$100 USD en 3 días
5,0 (35 comentarios)
4,7
4,7
Avatar del usuario
Hello sir I have done this task a couple of times in my past projects. I'm very much interested in doing this task for you. Thank you for giving your precious time to review my bid and check PM for more details!
$30 USD en 3 días
5,0 (19 comentarios)
4,6
4,6
Avatar del usuario
Dear Client, I have just finished up reading your post ..I have 6 Years in Joomla- 225 completed Projects - 140 Satisfied Client - 86 countries - 5 Star ratings on Freelancer/Elance. Still going strong, please check your Inbox for my message - Regards, Derick Rethans
$412 USD en 9 días
5,0 (4 comentarios)
4,5
4,5
Avatar del usuario
Hello. I'm MySQL database administrator specializing in performance optimization. Please check PMB where I propose few things that potentially can be done to improve speed of Your site
$150 USD en 3 días
5,0 (2 comentarios)
3,4
3,4
Avatar del usuario
Hi. Please check PM. Thanks.
$20 USD en 2 días
5,0 (1 comentario)
1,0
1,0
Avatar del usuario
Hi There. I am willing to do this project. Let me know if you are interested. Thanks.
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I can fix and optomaze your base, i do this every day
$15 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de MEXICO
Guasave, Mexico
4,9
43
Forma de pago verificada
Miembro desde jul 20, 2006

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.