Cientos de registros en POSTS y lentitud

[ANTONIO JOSE]

Hola:

Cuando entro en el escritorio de WP y hago clic en eventos, tarda muchísimo tiempo hasta que aparece la lista con todos los eventos. Cronometrado, tarda unos 45 segundos hasta que carga la primera página inicial. Lo cual es desesperante. Esto a pesar que lo que tengo son 2.302 elementos que no parecen muchos.

He revisado la tabla POST y veo que hay muchísimos datos que creo está creando el plugin EVENT AGREGATOR con el estatus “tribe-ea-failed“ , el últivo registro lleva el ID con el número 212683.

Me preocupa, porque no se si esto es normal y desconozco si es normal que el ID de esta tabla tenga ya un número tan elevado. Realmente esta tabla tiene 8.541 filas.

No se si estos registros son lo del Historial de la importación de eventos que he visto .

Saludos,
Antonio Ortiz

[ANTONIO JOSE]

This reply is private.

[Jaime Marchwinski]

Hola Antonio,

¡Muchas gracias por contactarnos!

Parece que sus importaciones de eventos pueden no funcionar correctamente. ¿Es esto cierto?

¿Qué ves si visitas Eventos < Ayuda y observas el estado del sistema del agregador de eventos? Puede tomar una captura de pantalla de lo que ve. También habilite el Registro de eventos encima de esto.

Mientras tanto, eche un vistazo a nuestras Consideraciones de rendimiento y vea si hay algo que pueda ajustar para ayudar a que su sitio funcione mejor:

https://theeventscalendar.com/knowledgebase/performance-considerations/

Después de eso, puede que le interese el almacenamiento en caché, así que eche un vistazo a este artículo:

https://theeventscalendar.com/knowledgebase/caching-basics/

Además, puede ver algunas de las soluciones proporcionadas en esta publicación en el foro:

https://theeventscalendar.com/support/forums/topic/decreasing-loading-time-for-big-amount-of-events/

También recomendaría buscar algunos de los complementos en esta publicación de blog, ya que pueden ayudarlo a identificar dónde puede estar ocurriendo la lentitud del sitio:

https://theeventscalendar.com/favorite-developer-plugins/

¡Déjame saber como va!

 

Thanks,

Jaime

[ANTONIO JOSE]

This reply is private.

[Jaime Marchwinski]

Hi Antonio,

Since you are already working on the issue of reaching your daily limit elsewhere, I will leave that issue there for now.

In regards to the performance on your site, it is normal for an ID to be created in the POSTS table, although the high volume of IDs created in your database may have to do with all of the failing imports.

You can install a plugin like Query Monitor, which may be able to give you some more information about what is slowing down your site.

Let me know how it goes and if you have any other questions along the way!

 

Thanks,

Jaime

[ANTONIO JOSE]

This reply is private.

[Jaime Marchwinski]

Hi Antonio,

I’m sorry to hear that you are still experiencing performance issues on your site.  Can you make sure that all of your Events Calendar related plugins are up to date, to ensure that they run optimally?

If you are not already doing this in another thread, perhaps the next step would be to understand what may be causing so many of your imports to fail.  As a next step, let’s try to rule out if there is some type of conflict at play.
This is usually because of:

1.    A conflict with another plugin

2.    A conflict with your WordPress theme

3.    A template customization for the Events Calendar that requires updating

When it comes to that type of issue, it is preferable to troubleshoot in a staging environment if you have one.

A first quick test is to simply temporarily revert back to a default WordPress theme such as twenty-sixteen to see if the issue persists.

The next step would be to go through our testing for conflicts procedure and let us know what you find out.

Basically the goal here is to revert back to a bare WordPress installation to see if the problem persists. It also allows us to pinpoint what the cause of the issue is.

But, before you do that, there are 2 things I would advise:

1.    Make a backup of your database

2.    Consider activating a “Maintenance Page” plugin if you are doing this on your live site (to minimize impact on your visitors)

Additionally, this blog post may be able to provide some more clarity about how to understand and use Query Monitor.

Let me know how that goes!

 

Thanks,

Jaime

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts